public FormArtPower( ) { InitializeComponent( ); _model = new ProductionErpEntity.ArtPowerEntity( ); _bll = new ProductionErpBll.Bll.ArtPowerBll( ); tableView = new DataTable( ); tablePerson = new DataTable( ); tableArt = new DataTable( ); strList = new List <string> ( ); Utility.GridViewMoHuSelect.SetFilter(gridView1); Utility.GridViewMoHuSelect.SetFilter(repositoryItemSearchLookUpEdit1View); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); barMenu.LinksPersistInfo.RemoveAt(toolExport.Id); barMenu.LinksPersistInfo.RemoveAt(toolPrint.Id); wait.Hide( ); gridView1.OptionsBehavior.Editable = false; tablePerson = _bll.tablePerson( ); lupPerson.Properties.DataSource = tablePerson; lupPerson.Properties.DisplayMember = "ARP002"; lupPerson.Properties.ValueMember = "ARP001"; getPerson( ); tableArt = _bll.getArt( ); resArt.DataSource = tableArt; resArt.DisplayMember = "ARP003"; resArt.ValueMember = "idx"; }
/// <summary> /// 保存数据 /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Save(DataTable table, List <string> strList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); ProductionErpEntity.ArtPowerEntity model = new ProductionErpEntity.ArtPowerEntity( ); DataRow row; for (int i = 0; i < table.Rows.Count; i++) { row = table.Rows [i]; model.ARP001 = row ["ARP001"].ToString( ); model.ARP002 = row ["ARP002"].ToString( ); model.ARP003 = row ["ARP003"].ToString( ); model.ARP004 = row ["ARP004"].ToString( ); if (!Exists(model)) { add(SQLString, strSql, model); } } if (strList != null && strList.Count > 0) { foreach (string s in strList) { model.idx = Convert.ToInt32(s); delete(SQLString, strSql, model); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
void delete(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.ArtPowerEntity model) { strSql = new StringBuilder( ); strSql.Append("DELETE FROM MOXARP "); strSql.AppendFormat("WHERE idx={0}", model.idx); SQLString.Add(strSql, null); }
/// <summary> /// 删除数据 /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Delete(DataTable table) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); ProductionErpEntity.ArtPowerEntity _model = new ProductionErpEntity.ArtPowerEntity( ); for (int i = 0; i < table.Rows.Count; i++) { _model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM MOXARP WHERE idx={0}", _model.idx); SQLString.Add(strSql, null); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
bool Exists(ProductionErpEntity.ArtPowerEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM MOXARP "); strSql.Append("WHERE ARP001=@ARP001 AND ARP003=@ARP003 AND ARP004=@ARP004"); SqlParameter [] parameter = { new SqlParameter("@ARP001", SqlDbType.NVarChar, 50), new SqlParameter("@ARP003", SqlDbType.NVarChar, 50), new SqlParameter("@ARP004", SqlDbType.NVarChar, 50) }; parameter [0].Value = model.ARP001; parameter [1].Value = model.ARP003; parameter [2].Value = model.ARP004; return(SqlHelper.Exists(strSql.ToString( ), parameter)); }
void add(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.ArtPowerEntity model) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO MOXARP ("); strSql.Append("ARP001,ARP002,ARP003,ARP004) "); strSql.Append("VALUES ("); strSql.Append("@ARP001,@ARP002,@ARP003,@ARP004) "); SqlParameter [] parameter = { new SqlParameter("@ARP001", SqlDbType.NVarChar, 50), new SqlParameter("@ARP002", SqlDbType.NVarChar, 50), new SqlParameter("@ARP003", SqlDbType.NVarChar, 50), new SqlParameter("@ARP004", SqlDbType.NVarChar, 50) }; parameter [0].Value = model.ARP001; parameter [1].Value = model.ARP002; parameter [2].Value = model.ARP003; parameter [3].Value = model.ARP004; SQLString.Add(strSql, parameter); }