/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.OrderMaterial model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_OrderMaterial("); strSql.Append("Orm_ID,MaterialID,SendCount,OrderID)"); strSql.Append(" values ("); strSql.Append("@Orm_ID,@MaterialID,@SendCount,@OrderID)"); SqlParameter[] parameters = { new SqlParameter("@Orm_ID", SqlDbType.Decimal, 9), new SqlParameter("@MaterialID", SqlDbType.VarChar, 30), new SqlParameter("@SendCount", SqlDbType.VarChar, 20), new SqlParameter("@OrderID", SqlDbType.VarChar, 20) }; parameters[0].Value = model.Orm_ID; parameters[1].Value = model.MaterialID; parameters[2].Value = model.SendCount; parameters[3].Value = model.OrderID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.OrderMaterial model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_OrderMaterial set "); strSql.Append("MaterialID=@MaterialID,"); strSql.Append("SendCount=@SendCount,"); strSql.Append("OrderID=@OrderID"); strSql.Append(" where Orm_ID=@Orm_ID "); SqlParameter[] parameters = { new SqlParameter("@MaterialID", SqlDbType.VarChar, 30), new SqlParameter("@SendCount", SqlDbType.VarChar, 20), new SqlParameter("@OrderID", SqlDbType.VarChar, 20), new SqlParameter("@Orm_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.MaterialID; parameters[1].Value = model.SendCount; parameters[2].Value = model.OrderID; parameters[3].Value = model.Orm_ID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(decimal Orm_ID) { Maticsoft.BLL.OrderMaterial bll = new Maticsoft.BLL.OrderMaterial(); Maticsoft.Model.OrderMaterial model = bll.GetModel(Orm_ID); this.lblOrm_ID.Text = model.Orm_ID.ToString(); this.txtMaterialID.Text = model.MaterialID; this.txtSendCount.Text = model.SendCount.ToString(); this.txtOrderID.Text = model.OrderID; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDecimal(txtOrm_ID.Text)) { strErr += "Orm_ID格式错误!\\n"; } if (this.txtMaterialID.Text.Trim().Length == 0) { strErr += "MaterialID不能为空!\\n"; } if (!PageValidate.IsNumber(txtSendCount.Text)) { strErr += "SendCount格式错误!\\n"; } if (this.txtOrderID.Text.Trim().Length == 0) { strErr += "OrderID不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } decimal Orm_ID = decimal.Parse(this.txtOrm_ID.Text); string MaterialID = this.txtMaterialID.Text; int SendCount = int.Parse(this.txtSendCount.Text); string OrderID = this.txtOrderID.Text; Maticsoft.Model.OrderMaterial model = new Maticsoft.Model.OrderMaterial(); model.Orm_ID = Orm_ID; model.MaterialID = MaterialID; model.SendCount = SendCount; model.OrderID = OrderID; Maticsoft.BLL.OrderMaterial bll = new Maticsoft.BLL.OrderMaterial(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.OrderMaterial DataRowToModel(DataRow row) { Maticsoft.Model.OrderMaterial model = new Maticsoft.Model.OrderMaterial(); if (row != null) { if (row["Orm_ID"] != null && row["Orm_ID"].ToString() != "") { model.Orm_ID = decimal.Parse(row["Orm_ID"].ToString()); } if (row["MaterialID"] != null) { model.MaterialID = row["MaterialID"].ToString(); } if (row["SendCount"] != null && row["SendCount"].ToString() != "") { model.SendCount = row["SendCount"].ToString(); } if (row["OrderID"] != null) { model.OrderID = row["OrderID"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.OrderMaterial GetModel(decimal Orm_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Orm_ID,MaterialID,SendCount,OrderID from tb_OrderMaterial "); strSql.Append(" where Orm_ID=@Orm_ID "); SqlParameter[] parameters = { new SqlParameter("@Orm_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = Orm_ID; Maticsoft.Model.OrderMaterial model = new Maticsoft.Model.OrderMaterial(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }