void AddHeader(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QuoEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into R_QUO("); strSql.Append("QUO001,QUO002,QUO003,QUO004,QUO005,QUO006,QUO007,QUO008,QUO009,QUO010)"); strSql.Append(" values ("); strSql.Append("@QUO001,@QUO002,@QUO003,@QUO004,@QUO005,@QUO006,@QUO007,@QUO008,@QUO009,@QUO010)"); SqlParameter [] parameters = { new SqlParameter("@QUO001", SqlDbType.NVarChar, 20), new SqlParameter("@QUO002", SqlDbType.NVarChar, 50), new SqlParameter("@QUO003", SqlDbType.NVarChar, 50), new SqlParameter("@QUO004", SqlDbType.NVarChar, 50), new SqlParameter("@QUO005", SqlDbType.NVarChar, 50), new SqlParameter("@QUO006", SqlDbType.NVarChar, 50), new SqlParameter("@QUO007", SqlDbType.Int, 4), new SqlParameter("@QUO008", SqlDbType.Date, 3), new SqlParameter("@QUO009", SqlDbType.Image), new SqlParameter("@QUO010", SqlDbType.NVarChar, 50) }; parameters [0].Value = model.QUO001; parameters [1].Value = model.QUO002; parameters [2].Value = model.QUO003; parameters [3].Value = model.QUO004; parameters [4].Value = model.QUO005; parameters [5].Value = model.QUO006; parameters [6].Value = model.QUO007; parameters [7].Value = model.QUO008; parameters [8].Value = model.QUO009; parameters [9].Value = model.QUO010; SQLString.Add(strSql, parameters); }
protected override void select( ) { SelectAll.FormQuotationQuery form = new SelectAll.FormQuotationQuery( ); if (form.ShowDialog( ) == DialogResult.OK) { _quo.QUO001 = form.getOdd; if (_quo.QUO001 == null || _quo.QUO001 == string.Empty) { return; } strWhere = "1=1"; strWhere = strWhere + " AND QUO001='" + _quo.QUO001 + "'"; _quo = _bll.getModel(strWhere); if (_quo == null) { return; } setValue( ); strWhere = "1=1"; strWhere += " AND QUR001='" + _quo.QUO001 + "'"; tableView = _bll.getTableView(strWhere); gridControl1.DataSource = tableView; toolAdd.Enabled = toolSelect.Enabled = toolDelete.Enabled = toolUpdate.Enabled = toolPrint.Enabled = toolExport.Enabled = toolLibrary.Enabled = toolStorage.Enabled = toolMaintain.Enabled = toolcopy.Enabled = toolReview.Enabled = true; toolSave.Enabled = toolCancel.Enabled = false; } base.select( ); }
/// <summary> /// 保存数据 /// </summary> /// <param name="_quo"></param> /// <param name="table"></param> /// <param name="state"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.QuoEntity _quo, DataTable table, string state, List <string> idxList) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (state.Equals("add")) { _quo.QUO001 = getOddNum( ); AddHeader(SQLString, strSql, _quo); } else { EditHeader(SQLString, strSql, _quo); } MulaolaoLibrary.QupEntity _qup = new MulaolaoLibrary.QupEntity( ); _qup.QUR001 = _quo.QUO001; for (int i = 0; i < table.Rows.Count; i++) { _qup.QUR002 = table.Rows [i] ["QUR002"].ToString( ); _qup.QUR003 = table.Rows [i] ["QUR003"].ToString( ); _qup.QUR004 = table.Rows [i] ["QUR004"].ToString( ); _qup.QUR005 = table.Rows [i] ["QUR005"].ToString( ); _qup.QUR006 = string.IsNullOrEmpty(table.Rows [i] ["QUR006"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR006"].ToString( )); _qup.QUR007 = table.Rows [i] ["QUR007"].ToString( ); _qup.QUR008 = table.Rows [i] ["QUR008"].ToString( ); _qup.QUR009 = table.Rows [i] ["QUR009"].ToString( ); _qup.QUR010 = string.IsNullOrEmpty(table.Rows [i] ["QUR010"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR010"].ToString( )); _qup.QUR011 = string.IsNullOrEmpty(table.Rows [i] ["QUR011"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR011"].ToString( )); _qup.QUR012 = string.IsNullOrEmpty(table.Rows [i] ["QUR012"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR012"].ToString( )); _qup.QUR013 = string.IsNullOrEmpty(table.Rows [i] ["QUR013"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR013"].ToString( )); _qup.QUR014 = string.IsNullOrEmpty(table.Rows [i] ["QUR014"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR014"].ToString( )); _qup.QUR016 = string.IsNullOrEmpty(table.Rows [i] ["QUR016"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR016"].ToString( )); _qup.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); _qup.QUR015 = table.Rows [i] ["QUR015"].ToString( ); if (_qup.idx < 1) { AddBody(SQLString, strSql, _qup); } else { EditBody(SQLString, strSql, _qup); } } if (idxList.Count > 0) { foreach (string s in idxList) { DeleteBody(SQLString, strSql, s); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
public FormQuotation( ) { InitializeComponent( ); _bll = new MulaolaoBll.Bll.QuoBll( ); _quo = new MulaolaoLibrary.QuoEntity( ); _qup = new MulaolaoLibrary.QupEntity( ); controlUnEnable( ); InitData( ); GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor }); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor }); dt = Drity.GetDt( ); }
public MulaolaoLibrary.QuoEntity getModel(DataRow row) { MulaolaoLibrary.QuoEntity model = new MulaolaoLibrary.QuoEntity( ); if (row != null) { if (row ["QUO001"] != null) { model.QUO001 = row ["QUO001"].ToString( ); } if (row ["QUO002"] != null) { model.QUO002 = row ["QUO002"].ToString( ); } if (row ["QUO003"] != null) { model.QUO003 = row ["QUO003"].ToString( ); } if (row ["QUO004"] != null) { model.QUO004 = row ["QUO004"].ToString( ); } if (row ["QUO005"] != null) { model.QUO005 = row ["QUO005"].ToString( ); } if (row ["QUO006"] != null) { model.QUO006 = row ["QUO006"].ToString( ); } if (row ["QUO007"] != null && row ["QUO007"].ToString( ) != "") { model.QUO007 = int.Parse(row ["QUO007"].ToString( )); } if (row ["QUO008"] != null && row ["QUO008"].ToString( ) != "") { model.QUO008 = DateTime.Parse(row ["QUO008"].ToString( )); } if (row ["QUO009"] != null && row ["QUO009"].ToString( ) != "") { model.QUO009 = ( byte [] )row ["QUO009"]; } if (row ["QUO010"] != null && row ["QUO010"].ToString( ) != "") { model.QUO010 = row ["QUO010"].ToString( ); } } return(model); }
void EditHeader(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QuoEntity model) { strSql = new StringBuilder( ); strSql.Append("update R_QUO set "); strSql.Append("QUO002=@QUO002,"); strSql.Append("QUO003=@QUO003,"); strSql.Append("QUO004=@QUO004,"); strSql.Append("QUO005=@QUO005,"); strSql.Append("QUO006=@QUO006,"); strSql.Append("QUO007=@QUO007,"); strSql.Append("QUO008=@QUO008,"); strSql.Append("QUO009=@QUO009,"); strSql.Append("QUO010=@QUO010 "); strSql.Append(" where QUO001=@QUO001"); SqlParameter [] parameters = { new SqlParameter("@QUO001", SqlDbType.NVarChar, 20), new SqlParameter("@QUO002", SqlDbType.NVarChar, 50), new SqlParameter("@QUO003", SqlDbType.NVarChar, 50), new SqlParameter("@QUO004", SqlDbType.NVarChar, 50), new SqlParameter("@QUO005", SqlDbType.NVarChar, 50), new SqlParameter("@QUO006", SqlDbType.NVarChar, 50), new SqlParameter("@QUO007", SqlDbType.Int, 4), new SqlParameter("@QUO008", SqlDbType.Date, 3), new SqlParameter("@QUO009", SqlDbType.Image), new SqlParameter("@QUO010", SqlDbType.NVarChar, 50), }; parameters [0].Value = model.QUO001; parameters [1].Value = model.QUO002; parameters [2].Value = model.QUO003; parameters [3].Value = model.QUO004; parameters [4].Value = model.QUO005; parameters [5].Value = model.QUO006; parameters [6].Value = model.QUO007; parameters [7].Value = model.QUO008; parameters [8].Value = model.QUO009; parameters [9].Value = model.QUO010; SQLString.Add(strSql, parameters); }
/// <summary> /// 保存数据 /// </summary> /// <param name="_quo"></param> /// <param name="table"></param> /// <param name="state"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Save(MulaolaoLibrary.QuoEntity _quo, DataTable table, string state, List <string> idxList) { return(dal.Save(_quo, table, state, idxList)); }