public Form2(DataTable tableOne, MaterileEntity.MaterielPDCEntity _pdc, string ContrNum, string productNum, string productName) { InitializeComponent( ); this._pdc = new MaterileEntity.MaterielPDCEntity( ); _pdd = new MaterileEntity.MaterielPDDEntity( ); _bll = new MaterielBll.Bll.MaterielTwoBll( ); toolQuery.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolAdd.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolSave.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolCancel.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolProv.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolNext.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolPrint.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolExport.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; this.txtContrNum.Text = ContrNum; this.txtCusNum.Tag = productNum; this.txtCusNum.Text = productName; this.table = tableOne; this._pdc = _pdc; query( ); }
void add_pdd_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDDEntity _pdd) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO TENPDD ("); strSql.Append("PDD001,PDD002,PDD003,PDD004,PDD005,PDD006,PDD007,PDD008,PDD009,PDD011,PDD012) "); strSql.Append("VALUES ("); strSql.Append("@PDD001,@PDD002,@PDD003,@PDD004,@PDD005,@PDD006,@PDD007,@PDD008,@PDD009,@PDD011,@PDD012)"); SqlParameter [] parameter = { new SqlParameter("@PDD001", SqlDbType.NVarChar, 200), new SqlParameter("@PDD002", SqlDbType.NVarChar, 10), new SqlParameter("@PDD003", SqlDbType.NVarChar, 200), new SqlParameter("@PDD004", SqlDbType.NVarChar, 200), new SqlParameter("@PDD005", SqlDbType.NVarChar, 200), new SqlParameter("@PDD006", SqlDbType.Int), new SqlParameter("@PDD007", SqlDbType.NVarChar, 200), new SqlParameter("@PDD008", SqlDbType.NVarChar, 200), new SqlParameter("@PDD009", SqlDbType.NVarChar, 200), new SqlParameter("@PDD011", SqlDbType.NVarChar, 200), new SqlParameter("@PDD012", SqlDbType.NVarChar, 200), }; parameter [0].Value = _pdd.PDD001; parameter [1].Value = _pdd.PDD002; parameter [2].Value = _pdd.PDD003; parameter [3].Value = _pdd.PDD004; parameter [4].Value = _pdd.PDD005; parameter [5].Value = _pdd.PDD006; parameter [6].Value = _pdd.PDD007; parameter [7].Value = _pdd.PDD008; parameter [8].Value = _pdd.PDD009; parameter [9].Value = _pdd.PDD011; parameter [10].Value = _pdd.PDD012; SQLString.Add(strSql, parameter); }
void add_pdd(Hashtable SQLString, StringBuilder strSql, Hashtable table_one_pdc, Hashtable table_two_pdc) { foreach (string key in table_two_pdc.Keys) { MaterileEntity.MaterielPDCEntity _pdc = (MaterileEntity.MaterielPDCEntity)table_two_pdc [key]; MaterileEntity.MaterielPDDEntity _pdd = new MaterileEntity.MaterielPDDEntity( ); _pdd.PDD001 = _pdc.PDC002; _pdd.PDD011 = _pdc.PDC005; _pdd.PDD012 = _pdc.PDC001; DataTable tableTre = ( DataTable )table_one_pdc [key]; DataTable dt = dtpdd(_pdd.PDD011, _pdd.PDD012); List <string> strList = new List <string> ( ); for (int i = 0; i < tableTre.Rows.Count; i++) { _pdd.PDD002 = tableTre.Rows [i] ["PDD002"].ToString( ); _pdd.PDD003 = tableTre.Rows [i] ["PDD003"].ToString( ); _pdd.PDD004 = tableTre.Rows [i] ["PDD004"].ToString( ); _pdd.PDD005 = tableTre.Rows [i] ["PDD005"].ToString( ); _pdd.PDD006 = string.IsNullOrEmpty(tableTre.Rows [i] ["PDD006"].ToString( )) == true ? 0 : Convert.ToInt32(tableTre.Rows [i] ["PDD006"].ToString( )); _pdd.PDD007 = tableTre.Rows [i] ["PDD007"].ToString( ); _pdd.PDD008 = tableTre.Rows [i] ["PDD008"].ToString( ); _pdd.PDD009 = tableTre.Rows [i] ["PDD009"].ToString( ); if (dt.Select("PDD002='" + _pdd.PDD002 + "'").Length > 0) { //if ( dt . Select ( "PDD002='" + _pdd . PDD002 + "' AND PDD003='" + _pdd . PDD003 + "' AND PDD004='" + _pdd . PDD004 + "' AND PDD005='" + _pdd . PDD005 + "' AND PDD006='" + _pdd . PDD006 + "' AND PDD007='" + _pdd . PDD007 + "' AND PDD008='" + _pdd . PDD008 + "' AND PDD009='" + _pdd . PDD009 + "' AND PDD011='" + _pdd . PDD011 + "' AND PDD012='" + _pdd . PDD012 + "'" ) . Length < 1 ) //{ // _pdd . PDD002 = dt . Compute ( "max(PDD002)" ,null ) . ToString ( ); // _pdd . PDD002 = ( Convert . ToInt32 ( _pdd . PDD002 ) + 1 ) . ToString ( ); // _pdd . PDD002 = _pdd . PDD002 . PadLeft ( 3 ,'0' ); // if ( strList . Contains ( _pdd . PDD002 ) == false ) // strList . Add ( _pdd . PDD002 ); // else // { // _pdd . PDD002 = strList . Max ( ); // _pdd . PDD002 = ( Convert . ToInt32 ( _pdd . PDD002 ) + 1 ) . ToString ( ); // _pdd . PDD002 = _pdd . PDD002 . PadLeft ( 3 ,'0' ); // strList . Add ( _pdd . PDD002 ); // } // add_pdd_one ( SQLString ,strSql ,_pdd ); //} //else edit_pdd(SQLString, strSql, _pdd); } else { add_pdd_one(SQLString, strSql, _pdd); } } } }
void edit_pdd(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDDEntity _pdd) { strSql = new StringBuilder( ); strSql.Append("UPDATE TENPDD SET "); strSql.Append("PDD003=@PDD003,"); strSql.Append("PDD004=@PDD004,"); strSql.Append("PDD005=@PDD005,"); strSql.Append("PDD006=@PDD006,"); strSql.Append("PDD007=@PDD007,"); strSql.Append("PDD008=@PDD008,"); strSql.Append("PDD009=@PDD009,"); strSql.Append("PDD001=@PDD001 "); strSql.Append("WHERE "); strSql.Append("PDD002=@PDD002 AND PDD011=@PDD011 AND PDD012=@PDD012"); SqlParameter [] parameter = { new SqlParameter("@PDD001", SqlDbType.NVarChar, 200), new SqlParameter("@PDD002", SqlDbType.NVarChar, 10), new SqlParameter("@PDD003", SqlDbType.NVarChar, 200), new SqlParameter("@PDD004", SqlDbType.NVarChar, 200), new SqlParameter("@PDD005", SqlDbType.NVarChar, 200), new SqlParameter("@PDD006", SqlDbType.Int), new SqlParameter("@PDD007", SqlDbType.NVarChar, 200), new SqlParameter("@PDD008", SqlDbType.NVarChar, 200), new SqlParameter("@PDD009", SqlDbType.NVarChar, 200), new SqlParameter("@PDD011", SqlDbType.NVarChar, 200), new SqlParameter("@PDD012", SqlDbType.NVarChar, 200) }; parameter [0].Value = _pdd.PDD001; parameter [1].Value = _pdd.PDD002; parameter [2].Value = _pdd.PDD003; parameter [3].Value = _pdd.PDD004; parameter [4].Value = _pdd.PDD005; parameter [5].Value = _pdd.PDD006; parameter [6].Value = _pdd.PDD007; parameter [7].Value = _pdd.PDD008; parameter [8].Value = _pdd.PDD009; parameter [9].Value = _pdd.PDD011; parameter [10].Value = _pdd.PDD012; SQLString.Add(strSql, parameter); }