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( ); }
bool Exists_pdc(MaterileEntity.MaterielPDCEntity _pdc) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM TENPDC "); strSql.AppendFormat("WHERE PDC001='{0}' AND PDC005='{1}'", _pdc.PDC001, _pdc.PDC005); return(SqlHelper.Exists(strSql.ToString( ))); }
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); } } } }