Ejemplo n.º 1
0
        /// <summary>
        /// save data to r_pqn,r_pqna
        /// </summary>
        /// <param name="model"></param>
        /// <param name="table"></param>
        /// <param name="strList"></param>
        /// <param name="logins"></param>
        /// <returns></returns>
        public bool Save(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins)
        {
            Hashtable     SQLString = new Hashtable( );
            StringBuilder strSql    = new StringBuilder( );

            model.KH01 = getOddNum( );
            add_pqn(SQLString, strSql, model);
            SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "新增", "增加"), null);

            MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( );
            _na.NA001 = model.KH01;
            for (int i = 0; i < table.Rows.Count; i++)
            {
                _na.NA002 = table.Rows [i] ["NA002"].ToString( );
                _na.NA003 = table.Rows [i] ["NA003"].ToString( );
                _na.NA004 = table.Rows [i] ["NA004"].ToString( );
                _na.NA005 = table.Rows [i] ["NA005"].ToString( );
                _na.NA006 = table.Rows [i] ["NA006"].ToString( );
                _na.NA007 = table.Rows [i] ["NA007"].ToString( );
                _na.NA008 = table.Rows [i] ["NA008"].ToString( );
                _na.NA009 = table.Rows [i] ["NA009"].ToString( );
                add_pqna(SQLString, strSql, _na);
            }

            return(SqlHelper.ExecuteSqlTran(SQLString));
        }
Ejemplo n.º 2
0
 void setVlues( )
 {
     tableView = _bll.getTableView(" NA001='" + _kh.KH01 + "'");
     gridControl1.DataSource = tableView;
     _kh = _bll.getModel(_kh.KH01);
     setValueHead( );
 }
Ejemplo n.º 3
0
        public R_FrmCustomerrecord( )
        {
            InitializeComponent();

            _kh         = new MulaolaoLibrary.CustomerrecordEntity( );
            _na         = new MulaolaoLibrary.CustomerrecordNAEntity( );
            _bll        = new MulaolaoBll.Bll.CustomerrecordBll( );
            tableView   = new DataTable( );
            lab.Visible = false;

            GridViewMoHuSelect.SetFilter(gridView1);
            GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.gridView1 });
            UserInfoMation.tableName = this.Name;
        }
Ejemplo n.º 4
0
        /// <summary>
        /// edit data to r_pqn,r_pqna
        /// </summary>
        /// <param name="model"></param>
        /// <param name="table"></param>
        /// <param name="logins"></param>
        /// <param name="strList"></param>
        /// <returns></returns>
        public bool Edit(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins, List <string> strList)
        {
            Hashtable     SQLString = new Hashtable( );
            StringBuilder strSql    = new StringBuilder( );

            edit_pqn(SQLString, strSql, model);
            SQLString.Add(Drity.DrityOfComparation("R_369", "客户信息传递记录表(R_369)", logins, Drity.GetDt( ), model.KH01, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑"), null);

            MulaolaoLibrary.CustomerrecordNAEntity _na = new MulaolaoLibrary.CustomerrecordNAEntity( );
            _na.NA001 = model.KH01;
            for (int i = 0; i < table.Rows.Count; i++)
            {
                _na.idx   = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
                _na.NA002 = table.Rows [i] ["NA002"].ToString( );
                _na.NA003 = table.Rows [i] ["NA003"].ToString( );
                _na.NA004 = table.Rows [i] ["NA004"].ToString( );
                _na.NA005 = table.Rows [i] ["NA005"].ToString( );
                _na.NA006 = table.Rows [i] ["NA006"].ToString( );
                _na.NA007 = table.Rows [i] ["NA007"].ToString( );
                _na.NA008 = table.Rows [i] ["NA008"].ToString( );
                _na.NA009 = table.Rows [i] ["NA009"].ToString( );
                if (_na.idx < 1)
                {
                    add_pqna(SQLString, strSql, _na);
                }
                else
                {
                    edit_pqna(SQLString, strSql, _na);
                }
            }

            if (strList.Count > 0)
            {
                foreach (string s in strList)
                {
                    _na.idx = Convert.ToInt32(s);
                    delete_pqna(SQLString, strSql, _na);
                }
            }

            return(SqlHelper.ExecuteSqlTran(SQLString));
        }
Ejemplo n.º 5
0
 /// <summary>
 /// edit data to r_pqn,r_pqna
 /// </summary>
 /// <param name="model"></param>
 /// <param name="table"></param>
 /// <param name="logins"></param>
 /// <param name="strList"></param>
 /// <returns></returns>
 public bool Edit(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins, List <string> strList)
 {
     return(_dal.Edit(model, table, logins, strList));
 }
Ejemplo n.º 6
0
 /// <summary>
 /// save data to r_pqn,r_pqna
 /// </summary>
 /// <param name="model"></param>
 /// <param name="table"></param>
 /// <param name="strList"></param>
 /// <param name="logins"></param>
 /// <returns></returns>
 public bool Save(MulaolaoLibrary.CustomerrecordEntity model, DataTable table, string logins)
 {
     return(_dal.Save(model, table, logins));
 }
Ejemplo n.º 7
0
        void edit_pqn(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordEntity model)
        {
            strSql = new StringBuilder( );
            strSql.Append("update R_PQN set ");
            strSql.Append("KH02=@KH02,");
            strSql.Append("KH03=@KH03,");
            strSql.Append("KH04=@KH04,");
            strSql.Append("KH05=@KH05,");
            strSql.Append("KH06=@KH06,");
            strSql.Append("KH07=@KH07,");
            strSql.Append("KH08=@KH08,");
            strSql.Append("KH09=@KH09,");
            strSql.Append("KH10=@KH10,");
            strSql.Append("KH11=@KH11,");
            strSql.Append("KH12=@KH12,");
            strSql.Append("KH13=@KH13,");
            strSql.Append("KH14=@KH14,");
            strSql.Append("KH15=@KH15,");
            strSql.Append("KH16=@KH16,");
            strSql.Append("KH17=@KH17,");
            strSql.Append("KH18=@KH18,");
            strSql.Append("KH19=@KH19,");
            strSql.Append("KH20=@KH20,");
            strSql.Append("KH21=@KH21,");
            strSql.Append("KH22=@KH22,");
            strSql.Append("KH23=@KH23,");
            strSql.Append("KH24=@KH24,");
            strSql.Append("KH25=@KH25,");
            strSql.Append("KH26=@KH26,");
            strSql.Append("KH27=@KH27,");
            strSql.Append("KH28=@KH28,");
            strSql.Append("KH29=@KH29,");
            strSql.Append("KH30=@KH30,");
            strSql.Append("KH31=@KH31,");
            strSql.Append("KH32=@KH32,");
            strSql.Append("KH33=@KH33,");
            strSql.Append("KH34=@KH34,");
            strSql.Append("KH35=@KH35 ");
            strSql.Append(" where KH01=@KH01");
            SqlParameter [] parameters =
            {
                new SqlParameter("@KH01", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH02", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH03", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH04", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH05", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH06", SqlDbType.Int,         4),
                new SqlParameter("@KH07", SqlDbType.VarBinary,  -1),
                new SqlParameter("@KH08", SqlDbType.Date,        3),
                new SqlParameter("@KH09", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH10", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH11", SqlDbType.Bit,         1),
                new SqlParameter("@KH12", SqlDbType.Bit,         1),
                new SqlParameter("@KH13", SqlDbType.Bit,         1),
                new SqlParameter("@KH14", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH15", SqlDbType.Bit,         1),
                new SqlParameter("@KH16", SqlDbType.Bit,         1),
                new SqlParameter("@KH17", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH18", SqlDbType.Bit,         1),
                new SqlParameter("@KH19", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH20", SqlDbType.Bit,         1),
                new SqlParameter("@KH21", SqlDbType.Bit,         1),
                new SqlParameter("@KH22", SqlDbType.Bit,         1),
                new SqlParameter("@KH23", SqlDbType.Bit,         1),
                new SqlParameter("@KH24", SqlDbType.Bit,         1),
                new SqlParameter("@KH25", SqlDbType.Bit,         1),
                new SqlParameter("@KH26", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH27", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH28", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH29", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH30", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH31", SqlDbType.Date,        3),
                new SqlParameter("@KH32", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH33", SqlDbType.Date,        3),
                new SqlParameter("@KH34", SqlDbType.NVarChar,  200),
                new SqlParameter("@KH35", SqlDbType.NVarChar, 200)
            };
            parameters [0].Value  = model.KH01;
            parameters [1].Value  = model.KH02;
            parameters [2].Value  = model.KH03;
            parameters [3].Value  = model.KH04;
            parameters [4].Value  = model.KH05;
            parameters [5].Value  = model.KH06;
            parameters [6].Value  = model.KH07;
            parameters [7].Value  = model.KH08;
            parameters [8].Value  = model.KH09;
            parameters [9].Value  = model.KH10;
            parameters [10].Value = model.KH11;
            parameters [11].Value = model.KH12;
            parameters [12].Value = model.KH13;
            parameters [13].Value = model.KH14;
            parameters [14].Value = model.KH15;
            parameters [15].Value = model.KH16;
            parameters [16].Value = model.KH17;
            parameters [17].Value = model.KH18;
            parameters [18].Value = model.KH19;
            parameters [19].Value = model.KH20;
            parameters [20].Value = model.KH21;
            parameters [21].Value = model.KH22;
            parameters [22].Value = model.KH23;
            parameters [23].Value = model.KH24;
            parameters [24].Value = model.KH25;
            parameters [25].Value = model.KH26;
            parameters [26].Value = model.KH27;
            parameters [27].Value = model.KH28;
            parameters [28].Value = model.KH29;
            parameters [29].Value = model.KH30;
            parameters [30].Value = model.KH31;
            parameters [31].Value = model.KH32;
            parameters [32].Value = model.KH33;
            parameters [33].Value = model.KH34;
            parameters [34].Value = model.KH35;

            SQLString.Add(strSql, parameters);
        }
Ejemplo n.º 8
0
        void add_pqn(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.CustomerrecordEntity model)
        {
            strSql = new StringBuilder( );
            strSql.Append("insert into R_PQN(");
            strSql.Append("KH01,KH02,KH03,KH04,KH05,KH06,KH07,KH08,KH09,KH10,KH11,KH12,KH13,KH14,KH15,KH16,KH17,KH18,KH19,KH20,KH21,KH22,KH23,KH24,KH25,KH26,KH27,KH28,KH29,KH30,KH31,KH32,KH33,KH34,KH35)");
            strSql.Append(" values (");
            strSql.Append("@KH01,@KH02,@KH03,@KH04,@KH05,@KH06,@KH07,@KH08,@KH09,@KH10,@KH11,@KH12,@KH13,@KH14,@KH15,@KH16,@KH17,@KH18,@KH19,@KH20,@KH21,@KH22,@KH23,@KH24,@KH25,@KH26,@KH27,@KH28,@KH29,@KH30,@KH31,@KH32,@KH33,@KH34,@KH35)");
            SqlParameter [] parameters =
            {
                new SqlParameter("@KH01", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH02", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH03", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH04", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH05", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH06", SqlDbType.Int,         4),
                new SqlParameter("@KH07", SqlDbType.VarBinary,  -1),
                new SqlParameter("@KH08", SqlDbType.Date,        3),
                new SqlParameter("@KH09", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH10", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH11", SqlDbType.Bit,         1),
                new SqlParameter("@KH12", SqlDbType.Bit,         1),
                new SqlParameter("@KH13", SqlDbType.Bit,         1),
                new SqlParameter("@KH14", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH15", SqlDbType.Bit,         1),
                new SqlParameter("@KH16", SqlDbType.Bit,         1),
                new SqlParameter("@KH17", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH18", SqlDbType.Bit,         1),
                new SqlParameter("@KH19", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH20", SqlDbType.Bit,         1),
                new SqlParameter("@KH21", SqlDbType.Bit,         1),
                new SqlParameter("@KH22", SqlDbType.Bit,         1),
                new SqlParameter("@KH23", SqlDbType.Bit,         1),
                new SqlParameter("@KH24", SqlDbType.Bit,         1),
                new SqlParameter("@KH25", SqlDbType.Bit,         1),
                new SqlParameter("@KH26", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH27", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH28", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH29", SqlDbType.NVarChar,  100),
                new SqlParameter("@KH30", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH31", SqlDbType.Date,        3),
                new SqlParameter("@KH32", SqlDbType.NVarChar,   20),
                new SqlParameter("@KH33", SqlDbType.Date,        3),
                new SqlParameter("@KH34", SqlDbType.NVarChar,  200),
                new SqlParameter("@KH35", SqlDbType.NVarChar, 200)
            };
            parameters [0].Value  = model.KH01;
            parameters [1].Value  = model.KH02;
            parameters [2].Value  = model.KH03;
            parameters [3].Value  = model.KH04;
            parameters [4].Value  = model.KH05;
            parameters [5].Value  = model.KH06;
            parameters [6].Value  = model.KH07;
            parameters [7].Value  = model.KH08;
            parameters [8].Value  = model.KH09;
            parameters [9].Value  = model.KH10;
            parameters [10].Value = model.KH11;
            parameters [11].Value = model.KH12;
            parameters [12].Value = model.KH13;
            parameters [13].Value = model.KH14;
            parameters [14].Value = model.KH15;
            parameters [15].Value = model.KH16;
            parameters [16].Value = model.KH17;
            parameters [17].Value = model.KH18;
            parameters [18].Value = model.KH19;
            parameters [19].Value = model.KH20;
            parameters [20].Value = model.KH21;
            parameters [21].Value = model.KH22;
            parameters [22].Value = model.KH23;
            parameters [23].Value = model.KH24;
            parameters [24].Value = model.KH25;
            parameters [25].Value = model.KH26;
            parameters [26].Value = model.KH27;
            parameters [27].Value = model.KH28;
            parameters [28].Value = model.KH29;
            parameters [29].Value = model.KH30;
            parameters [30].Value = model.KH31;
            parameters [31].Value = model.KH32;
            parameters [32].Value = model.KH33;
            parameters [33].Value = model.KH34;
            parameters [34].Value = model.KH35;

            SQLString.Add(strSql, parameters);
        }
Ejemplo n.º 9
0
        public MulaolaoLibrary.CustomerrecordEntity getModel(DataRow row)
        {
            MulaolaoLibrary.CustomerrecordEntity model = new MulaolaoLibrary.CustomerrecordEntity( );

            if (row != null)
            {
                if (row ["KH01"] != null)
                {
                    model.KH01 = row ["KH01"].ToString( );
                }
                if (row ["KH02"] != null)
                {
                    model.KH02 = row ["KH02"].ToString( );
                }
                if (row ["KH03"] != null)
                {
                    model.KH03 = row ["KH03"].ToString( );
                }
                if (row ["KH04"] != null)
                {
                    model.KH04 = row ["KH04"].ToString( );
                }
                if (row ["KH05"] != null)
                {
                    model.KH05 = row ["KH05"].ToString( );
                }
                if (row ["KH06"] != null && row ["KH06"].ToString( ) != "")
                {
                    model.KH06 = int.Parse(row ["KH06"].ToString( ));
                }
                if (row ["KH07"] != null && row ["KH07"].ToString( ) != "")
                {
                    model.KH07 = ( byte [] )row ["KH07"];
                }
                else
                {
                    model.KH07 = new byte [0];
                }
                if (row ["KH08"] != null && row ["KH08"].ToString( ) != "")
                {
                    model.KH08 = DateTime.Parse(row ["KH08"].ToString( ));
                }
                if (row ["KH09"] != null)
                {
                    model.KH09 = row ["KH09"].ToString( );
                }
                if (row ["KH10"] != null)
                {
                    model.KH10 = row ["KH10"].ToString( );
                }
                if (row ["KH11"] != null && row ["KH11"].ToString( ) != "")
                {
                    if ((row ["KH11"].ToString( ) == "1") || (row ["KH11"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH11 = true;
                    }
                    else
                    {
                        model.KH11 = false;
                    }
                }
                if (row ["KH12"] != null && row ["KH12"].ToString( ) != "")
                {
                    if ((row ["KH12"].ToString( ) == "1") || (row ["KH12"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH12 = true;
                    }
                    else
                    {
                        model.KH12 = false;
                    }
                }
                if (row ["KH13"] != null && row ["KH13"].ToString( ) != "")
                {
                    if ((row ["KH13"].ToString( ) == "1") || (row ["KH13"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH13 = true;
                    }
                    else
                    {
                        model.KH13 = false;
                    }
                }
                if (row ["KH14"] != null)
                {
                    model.KH14 = row ["KH14"].ToString( );
                }
                if (row ["KH15"] != null && row ["KH15"].ToString( ) != "")
                {
                    if ((row ["KH15"].ToString( ) == "1") || (row ["KH15"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH15 = true;
                    }
                    else
                    {
                        model.KH15 = false;
                    }
                }
                if (row ["KH16"] != null && row ["KH16"].ToString( ) != "")
                {
                    if ((row ["KH16"].ToString( ) == "1") || (row ["KH16"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH16 = true;
                    }
                    else
                    {
                        model.KH16 = false;
                    }
                }
                if (row ["KH17"] != null)
                {
                    model.KH17 = row ["KH17"].ToString( );
                }
                if (row ["KH18"] != null && row ["KH18"].ToString( ) != "")
                {
                    if ((row ["KH18"].ToString( ) == "1") || (row ["KH18"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH18 = true;
                    }
                    else
                    {
                        model.KH18 = false;
                    }
                }
                if (row ["KH19"] != null)
                {
                    model.KH19 = row ["KH19"].ToString( );
                }
                if (row ["KH20"] != null && row ["KH20"].ToString( ) != "")
                {
                    if ((row ["KH20"].ToString( ) == "1") || (row ["KH20"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH20 = true;
                    }
                    else
                    {
                        model.KH20 = false;
                    }
                }
                if (row ["KH21"] != null && row ["KH21"].ToString( ) != "")
                {
                    if ((row ["KH21"].ToString( ) == "1") || (row ["KH21"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH21 = true;
                    }
                    else
                    {
                        model.KH21 = false;
                    }
                }
                if (row ["KH22"] != null && row ["KH22"].ToString( ) != "")
                {
                    if ((row ["KH22"].ToString( ) == "1") || (row ["KH22"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH22 = true;
                    }
                    else
                    {
                        model.KH22 = false;
                    }
                }
                if (row ["KH23"] != null && row ["KH23"].ToString( ) != "")
                {
                    if ((row ["KH23"].ToString( ) == "1") || (row ["KH23"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH23 = true;
                    }
                    else
                    {
                        model.KH23 = false;
                    }
                }
                if (row ["KH24"] != null && row ["KH24"].ToString( ) != "")
                {
                    if ((row ["KH24"].ToString( ) == "1") || (row ["KH24"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH24 = true;
                    }
                    else
                    {
                        model.KH24 = false;
                    }
                }
                if (row ["KH25"] != null && row ["KH25"].ToString( ) != "")
                {
                    if ((row ["KH25"].ToString( ) == "1") || (row ["KH25"].ToString( ).ToLower( ) == "true"))
                    {
                        model.KH25 = true;
                    }
                    else
                    {
                        model.KH25 = false;
                    }
                }
                if (row ["KH26"] != null)
                {
                    model.KH26 = row ["KH26"].ToString( );
                }
                if (row ["KH27"] != null)
                {
                    model.KH27 = row ["KH27"].ToString( );
                }
                if (row ["KH28"] != null)
                {
                    model.KH28 = row ["KH28"].ToString( );
                }
                if (row ["KH29"] != null)
                {
                    model.KH29 = row ["KH29"].ToString( );
                }
                if (row ["KH30"] != null)
                {
                    model.KH30 = row ["KH30"].ToString( );
                }
                if (row ["KH31"] != null && row ["KH31"].ToString( ) != "")
                {
                    model.KH31 = DateTime.Parse(row ["KH31"].ToString( ));
                }
                if (row ["KH32"] != null)
                {
                    model.KH32 = row ["KH32"].ToString( );
                }
                if (row ["KH33"] != null && row ["KH33"].ToString( ) != "")
                {
                    model.KH33 = DateTime.Parse(row ["KH33"].ToString( ));
                }
                if (row ["KH34"] != null)
                {
                    model.KH34 = row ["KH34"].ToString( );
                }
                if (row ["KH35"] != null)
                {
                    model.KH35 = row ["KH35"].ToString( );
                }
            }

            return(model);
        }