/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.NewPort.Table_monthlyFeedback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Table_monthlyFeedback("); strSql.Append("monthlyFeedback_sn,monthlyFeedback_yyyyMM,project_id,monthlyFeedback_fulfilment,monthlyFeedback_fulfilmentDescription,monthlyFeedback_writer)"); strSql.Append(" values ("); strSql.Append("@monthlyFeedback_sn,@monthlyFeedback_yyyyMM,@project_id,@monthlyFeedback_fulfilment,@monthlyFeedback_fulfilmentDescription,@monthlyFeedback_writer)"); SqlParameter[] parameters = { new SqlParameter("@monthlyFeedback_sn", SqlDbType.Char, 10), new SqlParameter("@monthlyFeedback_yyyyMM", SqlDbType.DateTime, 3), new SqlParameter("@project_id", SqlDbType.Char, 8), new SqlParameter("@monthlyFeedback_fulfilment", SqlDbType.Float, 8), new SqlParameter("@monthlyFeedback_fulfilmentDescription", SqlDbType.NText), new SqlParameter("@monthlyFeedback_writer", SqlDbType.NChar, 20) }; parameters[0].Value = model.monthlyFeedback_sn; parameters[1].Value = model.monthlyFeedback_yyyyMM; parameters[2].Value = model.project_id; parameters[3].Value = model.monthlyFeedback_fulfilment; parameters[4].Value = model.monthlyFeedback_fulfilmentDescription; parameters[5].Value = model.monthlyFeedback_writer; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.Table_monthlyFeedback DataRowToModel(DataRow row) { Maticsoft.Model.NewPort.Table_monthlyFeedback model = new Maticsoft.Model.NewPort.Table_monthlyFeedback(); if (row != null) { if (row["monthlyFeedback_sn"] != null) { model.monthlyFeedback_sn = row["monthlyFeedback_sn"].ToString(); } if (row["monthlyFeedback_yyyyMM"] != null && row["monthlyFeedback_yyyyMM"].ToString() != "") { model.monthlyFeedback_yyyyMM = DateTime.Parse(row["monthlyFeedback_yyyyMM"].ToString()); } if (row["project_id"] != null) { model.project_id = row["project_id"].ToString(); } if (row["monthlyFeedback_fulfilment"] != null && row["monthlyFeedback_fulfilment"].ToString() != "") { model.monthlyFeedback_fulfilment = decimal.Parse(row["monthlyFeedback_fulfilment"].ToString()); } if (row["monthlyFeedback_fulfilmentDescription"] != null) { model.monthlyFeedback_fulfilmentDescription = row["monthlyFeedback_fulfilmentDescription"].ToString(); } if (row["monthlyFeedback_writer"] != null) { model.monthlyFeedback_fulfilmentDescription = row["monthlyFeedback_writer"].ToString(); } } return(model); }
private void ShowInfo(string strid) { Maticsoft.BLL.NewPort.Table_monthlyFeedback bll = new Maticsoft.BLL.NewPort.Table_monthlyFeedback(); Maticsoft.Model.NewPort.Table_monthlyFeedback model = bll.GetModel(strid); this.lbl_number.Text = model.project_id.ToString(); this.lbl_time.Text = model.monthlyFeedback_yyyyMM.ToString(); this.lbl_completed.Text = model.monthlyFeedback_fulfilment.ToString(); this.lbl_process.Text = model.monthlyFeedback_fulfilmentDescription.ToString(); }
protected void btnmBack_Click(object sender, EventArgs e) { Maticsoft.Model.NewPort.Table_monthlyFeedback model = new Maticsoft.Model.NewPort.Table_monthlyFeedback(); model.monthlyFeedback_sn = monid; model.project_id = DropDownList1.SelectedValue.ToString().Trim(); model.monthlyFeedback_yyyyMM = DateTime.Now.ToUniversalTime(); model.monthlyFeedback_fulfilmentDescription = this.txta.Value; model.monthlyFeedback_fulfilment = Decimal.Parse(this.txtInvestment.Text.Trim()); model.monthlyFeedback_writer = Session["UserName"].ToString(); Maticsoft.BLL.NewPort.Table_monthlyFeedback bll = new Maticsoft.BLL.NewPort.Table_monthlyFeedback(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "monthlyFeedbackCheck.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.NewPort.Table_monthlyFeedback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Table_monthlyFeedback set "); strSql.Append("monthlyFeedback_yyyyMM=@monthlyFeedback_yyyyMM,"); strSql.Append("project_id=@project_id,"); strSql.Append("monthlyFeedback_fulfilment=@monthlyFeedback_fulfilment,"); strSql.Append("monthlyFeedback_fulfilmentDescription=@monthlyFeedback_fulfilmentDescription"); strSql.Append("monthlyFeedback_writer=@monthlyFeedback_writer"); strSql.Append(" where monthlyFeedback_sn=@monthlyFeedback_sn "); SqlParameter[] parameters = { new SqlParameter("@monthlyFeedback_yyyyMM", SqlDbType.DateTime, 3), new SqlParameter("@project_id", SqlDbType.Char, 8), new SqlParameter("@monthlyFeedback_fulfilment", SqlDbType.Float, 8), new SqlParameter("@monthlyFeedback_fulfilmentDescription", SqlDbType.NText), new SqlParameter("@monthlyFeedback_writer", SqlDbType.NChar, 20), new SqlParameter("@monthlyFeedback_sn", SqlDbType.Char, 10) }; parameters[0].Value = model.monthlyFeedback_yyyyMM; parameters[1].Value = model.project_id; parameters[2].Value = model.monthlyFeedback_fulfilment; parameters[3].Value = model.monthlyFeedback_fulfilmentDescription; parameters[4].Value = model.monthlyFeedback_sn; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.Table_monthlyFeedback GetModel(string monthlyFeedback_sn) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 monthlyFeedback_sn,monthlyFeedback_yyyyMM,project_id,monthlyFeedback_fulfilment,monthlyFeedback_fulfilmentDescription,monthlyFeedback_writer from Table_monthlyFeedback "); strSql.Append(" where monthlyFeedback_sn=@monthlyFeedback_sn "); SqlParameter[] parameters = { new SqlParameter("@monthlyFeedback_sn", SqlDbType.Char, 10) }; parameters[0].Value = monthlyFeedback_sn; Maticsoft.Model.NewPort.Table_monthlyFeedback model = new Maticsoft.Model.NewPort.Table_monthlyFeedback(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }