MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Common/GetObjectData.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinEditors;
using System.Data;
using CoreFS.SA06;
//using Core.StlMes.Client.SaleOrder.Object;

namespace Core.StlMes.Client.SaleOrder
{
    class GetObjectData
    {
        /// <summary>
        /// 销售成分数据
        /// </summary>
        /// <param name="ugr"></param>
        /// <returns></returns>
        public static SlmCustChemObject GetStdChemObject(UltraGridRow ugr)
        {
            SlmCustChemObject com = new SlmCustChemObject();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.Cic = ugr.Cells["CIC"].Value.ToString().Trim(); 
            com.IndexSeq = ugr.Cells["INDEX_SEQ"].Value.ToString().Trim(); 
            com.ChemCode = ugr.Cells["CHEM_CODE"].Value.ToString().Trim();
            com.ChemName = ugr.Cells["CHEM_CODE"].Text; 
            com.ChemType = ugr.Cells["CHEM_TYPE"].Value.ToString().Trim(); 
            com.ChemFormula = ugr.Cells["CHEM_FORMULA"].Value.ToString().Trim(); 
            com.Ischeck = ugr.Cells["ISCHECK"].Value.ToString() == "True" ? "1" : "0";
            com.Isjudge = ugr.Cells["ISJUDGE"].Value.ToString() == "True" ? "1" : "0";
            com.Isquote = ugr.Cells["ISQUOTE"].Value.ToString() == "True" ? "1" : "0";
            com.ComplexType = ugr.Cells["COMPLEX_TYPE"].Value.ToString() == "True" ? "1" : "0";
            com.StdminSign = ugr.Cells["STDMIN_SIGN1"].Value.ToString().Trim(); 
            com.Stdmin = ugr.Cells["STDMIN1"].Value.ToString().Trim(); 
            com.StdmaxSign = ugr.Cells["STDMAX_SIGN1"].Value.ToString().Trim(); 
            com.Stdmax = ugr.Cells["STDMAX1"].Value.ToString().Trim(); 
            com.Stdtarget = ugr.Cells["STDTARGET"].Value.ToString().Trim(); 
            com.ModelCode = ugr.Cells["MODEL_CODE"].Value.ToString().Trim(); 
            com.ModelDesc = ugr.Cells["MODEL_DESC"].Value.ToString().Trim(); 
            com.Stdmemo = ugr.Cells["STDMEMO"].Value.ToString().Trim(); 
            com.EleCode = ugr.Cells["ELE_CODE"].Value.ToString().Trim(); 
            com.EleName = ugr.Cells["ELE_NAME"].Value.ToString().Trim(); 
            com.EleMinSign = ugr.Cells["ELE_MIN_SIGN"].Value.ToString().Trim(); 
            com.EleMin = ugr.Cells["ELE_MIN"].Value.ToString().Trim(); 
            com.EleMaxSign = ugr.Cells["ELE_MAX_SIGN"].Value.ToString().Trim(); 
            com.EleMax = ugr.Cells["ELE_MAX"].Value.ToString().Trim(); 
            //com.SizeCode2 = ugr.Cells["SIZE_CODE2"].Value.ToString().Trim(); 
            //com.SizeName2 = ugr.Cells["SIZE_NAME2"].Value.ToString().Trim(); 
            //com.SizeMinSign2 = ugr.Cells["SIZE_MIN_SIGN2"].Value.ToString().Trim(); 
            //com.SizeMin2 = ugr.Cells["SIZE_MIN2"].Value.ToString().Trim(); 
            //com.SizeMaxSign2 = ugr.Cells["SIZE_MAX_SIGN2"].Value.ToString().Trim(); 
            //com.SizeMax2 = ugr.Cells["SIZE_MAX2"].Value.ToString().Trim(); 
            //com.SizeCode = ugr.Cells["SIZE_CODE"].Value.ToString().Trim(); 
            //com.SizeName = ugr.Cells["SIZE_NAME"].Value.ToString().Trim(); 
            //com.SizeMinSign = ugr.Cells["SIZE_MIN_SIGN"].Value.ToString().Trim(); 
            //com.SizeMin = ugr.Cells["SIZE_MIN"].Value.ToString().Trim(); ;
            //com.SizeMaxSign = ugr.Cells["SIZE_MAX_SIGN"].Value.ToString().Trim(); 
            //com.SizeMax = ugr.Cells["SIZE_MAX"].Value.ToString().Trim(); 
            com.SpecJg = ugr.Cells["SPEC_JG"].Value.ToString().Trim(); 
            com.SpecJgDesc = ugr.Cells["SPEC_JG_DESC"].Value.ToString().Trim();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = ugr.Cells["CREATE_NAME"].Value.ToString().Trim();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = ugr.Cells["UPDATE_NAME"].Value.ToString().Trim();
            com.UpdateTime = ugr.Cells["UPDATE_TIME"].Value.ToString().Trim();
            com.DeleteName = ugr.Cells["DELETE_NAME"].Value.ToString().Trim();
            com.DeleteTime = ugr.Cells["DELETE_TIME"].Value.ToString().Trim();
            com.RepMaxSign = ugr.Cells["REP_MAX_SIGN"].Value.ToString().Trim();
            com.RepMin = ugr.Cells["REP_MIN"].Value.ToString().Trim(); ;
            com.RepMinSign = ugr.Cells["REP_MIN_SIGN"].Value.ToString().Trim();
            com.RepMax = ugr.Cells["REP_MAX"].Value.ToString().Trim();
            com.RepName = ugr.Cells["REP_NAME"].Value.ToString().Trim();
            com.RepCode = ugr.Cells["REP_CODE"].Value.ToString().Trim();
            com.RepVal = ugr.Cells["REP_VAL"].Value.ToString().Trim();
            com.Stdmemo = ugr.Cells["STDMEMO1"].Value.ToString().Trim();
            return com;
        }

        public static SlmCustPhyObject GetSlmCustPhyData(UltraGridRow ugr)
        {
            SlmCustPhyObject com = new SlmCustPhyObject();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.Pic = ugr.Cells["PIC"].Value.ToString().Trim(); 
            com.IndexSeq = ugr.Cells["INDEX_SEQ"].Value.ToString().Trim();
            com.PhyCodeMax = ugr.Cells["PHY_CODE_MAX"].Value.ToString();
            com.PhyNameMax = ugr.Cells["PHY_NAME_MAX"].Text;
            com.PhyCodeMin = ugr.Cells["PHY_CODE_MIN"].Value.ToString();
            com.PhyNameMin = ugr.Cells["PHY_NAME_MIN"].Value.ToString();
            com.PhyCode = ugr.Cells["PHY_CODE"].Value.ToString();
            com.PhyName = ugr.Cells["PHY_NAME"].Value.ToString();
            com.ItemCodeF = ugr.Cells["ITEM_CODE_F"].Value.ToString();
            com.ItemNameF = ugr.Cells["ITEM_NAME_F"].Value.ToString();
            com.ItemCodeW = ugr.Cells["ITEM_CODE_W"].Value.ToString();
            com.ItemNameW = ugr.Cells["ITEM_NAME_W"].Value.ToString();
            com.ItemCodeS = ugr.Cells["ITEM_CODE_S"].Value.ToString();
            com.ItemNameS = ugr.Cells["ITEM_NAME_S"].Value.ToString();
            com.GroupSeq = ugr.Cells["GROUP_SEQ"].Value.ToString().Trim();
            com.Ischeck = ugr.Cells["ISCHECK"].Value.ToString() == "True" ? "1" : "0";
            com.Isquote = ugr.Cells["ISQUOTE"].Value.ToString() == "True" ? "1" : "0";
            com.ResultCount = ugr.Cells["RESULT_COUNT"].Value.ToString().Trim();
            com.Isjudge = ugr.Cells["ISJUDGE"].Value.ToString() == "True" ? "1" : "0";
            com.PhyType = ugr.Cells["PHY_TYPE"].Value.ToString() == "True" ? "1" : "0";
            com.PhyFormula = ugr.Cells["PHY_FORMULA"].Value.ToString().Trim();
            com.StdminSign = ugr.Cells["STDMIN_SIGN1"].Value.ToString().Trim();
            com.Stdmin = ugr.Cells["STDMIN1"].Value.ToString().Trim();
            com.StdmaxSign = ugr.Cells["STDMAX_SIGN1"].Value.ToString().Trim();
            com.Stdmax = ugr.Cells["STDMAX1"].Value.ToString().Trim();
            com.JudgeBasis = ugr.Cells["JUDGE_BASIS"].Value.ToString().Trim();
            com.Deliverystate = ugr.Cells["DELIVERYSTATE"].Value.ToString().Trim();
            com.ModelCode = ugr.Cells["MODEL_CODE"].Value.ToString().Trim();
            com.ModelDesc = ugr.Cells["MODEL_DESC"].Value.ToString().Trim();
            com.Stdmemo = ugr.Cells["STDMEMO"].Value.ToString().Trim();
            //com.SizeCode = ugr.Cells["SIZE_CODE"].Value.ToString().Trim();
            //com.SizeName = ugr.Cells["SIZE_NAME"].Value.ToString().Trim();
            //com.SizeMinSign = ugr.Cells["SIZE_MIN_SIGN"].Value.ToString().Trim();
            //com.SizeMin = ugr.Cells["SIZE_MIN"].Value.ToString().Trim();
            //com.SizeMaxSign = ugr.Cells["SIZE_MAX_SIGN"].Value.ToString().Trim();
            //com.SizeMax = ugr.Cells["SIZE_MAX"].Value.ToString().Trim();
            //com.SizeCode2 = ugr.Cells["SIZE_CODE2"].Value.ToString().Trim();
            //com.SizeName2 = ugr.Cells["SIZE_NAME2"].Value.ToString().Trim();
            //com.SizeMinSign2 = ugr.Cells["SIZE_MIN_SIGN2"].Value.ToString().Trim();
            //com.SizeMin2 = ugr.Cells["SIZE_MIN2"].Value.ToString().Trim();
            //com.SizeMaxSign2 = ugr.Cells["SIZE_MAX_SIGN2"].Value.ToString().Trim();
            //com.SizeMax2 = ugr.Cells["SIZE_MAX2"].Value.ToString().Trim();
            com.SpecJg = ugr.Cells["SPEC_JG"].Value.ToString().Trim();
            com.SpecJgDesc = ugr.Cells["SPEC_JG_DESC"].Value.ToString().Trim();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = ugr.Cells["CREATE_NAME"].Value.ToString().Trim();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = ugr.Cells["UPDATE_NAME"].Value.ToString().Trim();
            com.UpdateTime = ugr.Cells["UPDATE_TIME"].Value.ToString().Trim();
            com.DeleteName = ugr.Cells["DELETE_NAME"].Value.ToString().Trim();
            com.DeleteTime = ugr.Cells["DELETE_TIME"].Value.ToString().Trim();
            com.Addcondition = ugr.Cells["ADDCONDITION"].Value.ToString().Trim();
            com.AddstdconCode = ugr.Cells["ADDSTDCON_CODE"].Value.ToString().Trim();
            com.AddstdMinSign = ugr.Cells["ADDSTD_MIN_SIGN"].Value.ToString().Trim();
            com.AddstdMin = ugr.Cells["ADDSTD_MIN"].Value.ToString().Trim();
            com.AddstdMaxSign = ugr.Cells["ADDSTD_MAX_SIGN"].Value.ToString().Trim();
            com.AddstdMax = ugr.Cells["ADDSTD_MAX"].Value.ToString().Trim();
            com.Addpercent = ugr.Cells["ADDPERCENT"].Value.ToString().Trim();
            com.StdminSign2 = ugr.GetValue("STDMIN_SIGN2");
            com.Stdmin2 = ugr.GetValue("STDMIN2");
            com.StdmaxSign2 = ugr.GetValue("STDMAX_SIGN2");
            com.Stdmax2 = ugr.GetValue("STDMAX2");
            com.StdChoose = ugr.GetValue("STD_CHOOSE");
            com.Guid = ugr.Cells["GUID"].Value.ToString().Trim();
            com.Stdmemo = ugr.Cells["STDMEMO1"].Value.ToString().Trim();
            return com;
        }

        public static SlmCustSpecObject GetSlmCustSpecData(UltraGridRow ugr) 
        {
            SlmCustSpecObject com = new SlmCustSpecObject();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.Sic = ugr.Cells["SIC"].Value.ToString().Trim(); 
            com.IndexSeq = ugr.Cells["INDEX_SEQ"].Value.ToString().Trim();
            com.BiasCode = ugr.Cells["BIAS_CODE"].Value.ToString().Trim();
            com.BiasName = ugr.Cells["BIAS_CODE"].Text;
            com.Lv = ugr.Cells["LV"].Value.ToString().Trim();
            //com.BiasCodeZ = ugr.Cells["BIAS_CODE_Z"].Value.ToString().Trim();
            //com.BiasNameZ = ugr.Cells["BIAS_NAME_Z"].Value.ToString().Trim();
            //com.ZminSign = ugr.Cells["ZMIN_SIGN"].Value.ToString().Trim();
            //com.Zmin = ugr.Cells["ZMIN"].Value.ToString().Trim();
            //com.ZmaxSign = ugr.Cells["ZMAX_SIGN"].Value.ToString().Trim();
            //com.Zmax = ugr.Cells["ZMAX"].Value.ToString().Trim();
            //com.BiasCodeC = ugr.Cells["BIAS_CODE_C"].Value.ToString().Trim();
            //com.BiasNameC = ugr.Cells["BIAS_NAME_C"].Value.ToString().Trim();
            //com.CminSign = ugr.Cells["CMIN_SIGN"].Value.ToString().Trim();
            //com.Cmin = ugr.Cells["CMIN"].Value.ToString().Trim();
            //com.CmaxSign = ugr.Cells["CMAX_SIGN"].Value.ToString().Trim();
            //com.Cmax = ugr.Cells["CMAX"].Value.ToString().Trim();
            //com.BiasCodeS = ugr.Cells["BIAS_CODE_S"].Value.ToString().Trim();
            //com.BiasNameS = ugr.Cells["BIAS_NAME_S"].Value.ToString().Trim();
            //com.Cmin2 = ugr.Cells["CMIN2"].Value.ToString().Trim();
            //com.CmaxSign2 = ugr.Cells["CMAX_SIGN2"].Value.ToString().Trim();
            //com.Cmax2 = ugr.Cells["CMAX2"].Value.ToString().Trim();
            com.Ischeck = ugr.Cells["ISCHECK"].Value.ToString() == "True" ? "1" : "0";
            com.StdMinVal = ugr.Cells["STD_MIN_VAL1"].Value.ToString().Trim();
            com.StdMaxVal = ugr.Cells["STD_MAX_VAL1"].Value.ToString().Trim();
            com.StdMinIn = ugr.Cells["STD_MIN_IN"].Value.ToString().Trim();
            com.StdMaxIn = ugr.Cells["STD_MAX_IN"].Value.ToString().Trim();
            com.StdMinPercent = ugr.Cells["STD_MIN_PERCENT1"].Value.ToString().Trim();
            com.StdMaxPercent = ugr.Cells["STD_MAX_PERCENT1"].Value.ToString().Trim();
            com.StdMinFormula = ugr.Cells["STD_MIN_FORMULA"].Value.ToString().Trim();
            com.StdMaxFormula = ugr.Cells["STD_MAX_FORMULA"].Value.ToString().Trim();
            com.StdMinFormulaV = ugr.Cells["STD_MIN_FORMULA_V1"].Value.ToString().Trim();
            if (Convert.ToBoolean(com.StdMinFormulaV))
                com.StdMinFormulaV = "1";
            else
                com.StdMinFormulaV = "0";
            com.StdMaxFormulaV = ugr.Cells["STD_MAX_FORMULA_V1"].Value.ToString().Trim();
            if (Convert.ToBoolean(com.StdMaxFormulaV))
                com.StdMaxFormulaV = "1";
            else
                com.StdMaxFormulaV = "0";
            com.Stdmemo = ugr.Cells["STDMEMO"].Value.ToString().Trim();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = ugr.Cells["CREATE_NAME"].Value.ToString().Trim();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = ugr.Cells["UPDATE_NAME"].Value.ToString().Trim();
            com.UpdateTime = ugr.Cells["UPDATE_TIME"].Value.ToString().Trim();
            com.DeleteName = ugr.Cells["DELETE_NAME"].Value.ToString().Trim();
            com.DeleteTime = ugr.Cells["DELETE_TIME"].Value.ToString().Trim();
            com.Stdmemo = ugr.Cells["STDMEMO1"].Value.ToString().Trim();
            return com;
        }


        public static SlmCustDetectionObject GetSlmCustDetectionData(UltraGridRow ugr) 
        {
            SlmCustDetectionObject com = new SlmCustDetectionObject();
            com.Dic = ugr.Cells["DIC"].Value.ToString().Trim(); 
            com.Xh = ugr.Cells["XH"].Value.ToString().Trim();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.PhyCode = ugr.Cells["PHY_CODE"].Value.ToString().Trim();
            com.PhyName = ugr.Cells["PHY_CODE"].Text;
            com.PositionCode = ugr.Cells["POSITION_CODE1"].Value.ToString().Trim();
            com.PositionDesc = ugr.Cells["POSITION_CODE1"].Text.Trim();
            com.StdDesc = ugr.Cells["STD_CODE1"].Value.ToString().Trim();
            com.LvCode = ugr.Cells["LV_CODE1"].Value.ToString().Trim();
            com.LvDesc = ugr.Cells["LV_DESC1"].Text;
            com.GroovePos = ugr.Cells["GROOVE_POS1"].Text;
            com.GrooveDir = ugr.Cells["GROOVE_DIR1"].Text;
            com.Coverage = ugr.Cells["COVERAGE1"].Value.ToString().Trim();
            com.Rate = ugr.GetValue("RATE1");
            com.DescRate = ugr.GetText("RATE1");
            com.DescVal = ugr.GetValue("DESC_VAL1");
            com.Memo = ugr.Cells["MEMO"].Value.ToString().Trim();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = ugr.Cells["CREATE_NAME"].Value.ToString().Trim();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = ugr.Cells["UPDATE_NAME"].Value.ToString().Trim();
            com.UpdateTime = ugr.Cells["UPDATE_TIME"].Value.ToString().Trim();
            com.DeleteName = ugr.Cells["DELETE_NAME"].Value.ToString().Trim();
            com.DeleteTime = ugr.Cells["DELETE_TIME"].Value.ToString().Trim();
            //com.MinD = ugr.GetValue("MIN_D");
            //com.MaxD = ugr.GetValue("MAX_D");
            //com.MinH = ugr.GetValue("MIN_H");
            //com.MaxH = ugr.GetValue("MAX_H");
            com.Memo = ugr.GetValue("MEMO1").Trim();
            return com;
        }

        public static SlmCustWaterObject GetSlmCustWaterData(UltraGridRow ugr) 
        {
            SlmCustWaterObject com = new SlmCustWaterObject();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.Wic = ugr.Cells["WIC"].Value.ToString().Trim(); 
            com.IndexSeq = ugr.Cells["INDEX_SEQ"].Value.ToString().Trim();
            com.PressureY = ugr.Cells["PRESSURE_Y1"].Value.ToString().Trim();
            com.Pressure = ugr.Cells["PRESSURE1"].Value.ToString().Trim();
            com.Formula = ugr.Cells["FORMULA1"].Text;
            com.SaveTime = ugr.Cells["SAVE_TIME1"].Value.ToString().Trim();
            com.GetMaxvalue = ugr.Cells["GET_MAXVALUE"].Value.ToString() == "True" ? "1" : "0";
            com.GetMinvalue = ugr.Cells["GET_MINVALUE"].Value.ToString() == "True" ? "1" : "0";
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = ugr.Cells["CREATE_NAME"].Value.ToString().Trim();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = ugr.Cells["UPDATE_NAME"].Value.ToString().Trim();
            com.UpdateTime = ugr.Cells["UPDATE_TIME"].Value.ToString().Trim();
            com.DeleteName = ugr.Cells["DELETE_NAME"].Value.ToString().Trim();
            com.DeleteTime = ugr.Cells["DELETE_TIME"].Value.ToString().Trim();
            com.Memo = ugr.Cells["MEMO1"].Value.ToString().Trim();
            return com;
        }
        /// <summary>
        /// 赋值给加工要求表
        /// </summary>
        /// <param name="ugr"></param>
        /// <returns></returns>
        public static SlmCustAlphaProObject GetSlmCustAlphaProData(UltraGridRow ugr)
        {
            /*
             cust_alpha_no, gic, xh, station_code, station_desc,
             process_cdoe, process_desc, process_cdoe_c, process_desc_c,
             value_text, value_num, value_memo, group_seq, validflag,
             create_name, create_time
             */
            SlmCustAlphaProObject com = new SlmCustAlphaProObject();
            com.CustAlphaNo = ugr.Cells["CUST_ALPHA_NO"].Value.ToString().Trim();
            com.Gic = ugr.Cells["GIC"].Value.ToString().Trim();
            com.Xh = ugr.Cells["XH"].Value.ToString().Trim();
            com.StationCode = ugr.Cells["STATION_CODE"].Value.ToString().Trim();
            com.StationDesc = ugr.Cells["STATION_DESC"].Text.Trim();
            com.ProcessCdoe = ugr.Cells["PROCESS_CDOE"].Value.ToString().Trim();
            com.ProcessDesc = ugr.Cells["PROCESS_DESC"].Value.ToString().Trim();
            com.ProcessCdoeC = ugr.Cells["PROCESS_CDOE_C"].Value.ToString().Trim();
            com.ProcessDescC = ugr.Cells["PROCESS_DESC_C"].Value.ToString().Trim();
            com.ValueText = ugr.Cells["ALPHA_VALUE_TEXT"].Value.ToString().Trim();
            com.ValueNum = ugr.Cells["ALPHA_VALUE_NUM"].Value.ToString().Trim();
            com.ValueMemo = ugr.Cells["ALPHA_VALUE_MEMO"].Value.ToString().Trim();
            com.GroupSeq = ugr.Cells["GROUP_SEQ"].Value.ToString().Trim();
            com.Validflag = ugr.GetValue("VALIDFLAG");
            com.Memo = ugr.GetValue("MEMO1").Trim();
            return com;
        }

        public static SlmOrderAddAskObject GetSlmOrderAddAskData(UltraGridRow ugr)
        {
            SlmOrderAddAskObject com = new SlmOrderAddAskObject();
            com.AddAskNo = ugr.Cells["ADD_ASK_NO"].Value.ToString().Trim();
            com.AskItme = ugr.Cells["ASK_ITME"].Value.ToString().Trim();
            com.AskItmeDesc = ugr.Cells["ASK_ITME_DESC"].Value.ToString().Trim();
            com.AskSubItme = ugr.Cells["ASK_SUB_ITME"].Value.ToString().Trim();
            com.AskSubItmeDesc = ugr.Cells["ASK_SUB_ITME_DESC"].Value.ToString().Trim();
            com.AskSubItmeVal = ugr.Cells["ASK_SUB_ITME_VAL1"].Value.ToString().Trim();
            com.AskSubItmeValDesc = ugr.Cells["ASK_SUB_ITME_VAL_DESC1"].Value.ToString().Trim();
            if ("12100101".Equals(com.AskSubItme))
            {
                com.AskSubItmeVal = ugr.Cells["ASK_SUB_ITME_VAL"].Value.ToString().Trim() + ugr.Cells["ASK_SUB_ITME_VAL1"].Value.ToString().Trim();
                com.AskSubItmeValDesc = ugr.Cells["ASK_SUB_ITME_VAL_DESC"].Value.ToString().Trim() + ugr.Cells["ASK_SUB_ITME_VAL_DESC1"].Value.ToString().Trim();
            }
            //com.Pic = ugr.Cells["PIC1"].Value.ToString().Trim(); //图片路径在选择时保存。
            com.CustomerNm = ugr.Cells["CUSTOMER_NM"].Value.ToString().Trim();
            com.Psc = ugr.Cells["PSC"].Value.ToString().Trim();
            com.PscDesc = ugr.Cells["PSC_DESC"].Value.ToString().Trim();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.CreateName = CoreUserInfo.UserInfo.GetUserName();
            com.AskItmeOld = ugr.GetValue("ASK_ITME_OLD");
            com.AskSubItmeOld = ugr.GetValue("ASK_SUB_ITME_OLD");
            com.AddAskStatus = "W";
            return com;
        }
    }
}