/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.ChangeMeterRegist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ChangeMeterRegist("); strSql.Append("UsersID,UserCode,OldNumber,NewMeterAddr,Remark,Status,ImagePath,OperatorCode,NewNumber,NewMeterId,InsertDate,ChangeMeterDate,MeterID)"); strSql.Append(" values ("); strSql.Append("@UsersID,@UserCode,@OldNumber,@NewMeterAddr,@Remark,@Status,@ImagePath,@OperatorCode,@NewNumber,@NewMeterId,@InsertDate,@ChangeMeterDate,@MeterID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UsersID", SqlDbType.Int, 4), new SqlParameter("@UserCode", SqlDbType.VarChar, 100), new SqlParameter("@OldNumber", SqlDbType.Decimal, 9), new SqlParameter("@NewMeterAddr", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@ImagePath", SqlDbType.VarChar, 8000), new SqlParameter("@OperatorCode", SqlDbType.VarChar, 100), new SqlParameter("@NewNumber", SqlDbType.Decimal, 9), new SqlParameter("@NewMeterId", SqlDbType.Int, 4), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@ChangeMeterDate", SqlDbType.DateTime), new SqlParameter("@MeterID", SqlDbType.Int, 4) }; parameters[0].Value = model.UsersID; parameters[1].Value = model.UserCode; parameters[2].Value = model.OldNumber; parameters[3].Value = model.NewMeterAddr; parameters[4].Value = model.Remark; parameters[5].Value = model.Status; parameters[6].Value = model.ImagePath; parameters[7].Value = model.OperatorCode; parameters[8].Value = model.NewNumber; parameters[9].Value = model.NewMeterId; parameters[10].Value = model.InsertDate; parameters[11].Value = model.ChangeMeterDate; parameters[12].Value = model.MeterID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int ID) { WebDemo.BLL.WebDemo.ChangeMeterRegist bll = new WebDemo.BLL.WebDemo.ChangeMeterRegist(); WebDemo.Model.WebDemo.ChangeMeterRegist model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.txtUsersID.Text = model.UsersID.ToString(); this.txtUserCode.Text = model.UserCode; this.txtOldNumber.Text = model.OldNumber.ToString(); this.txtNewMeterAddr.Text = model.NewMeterAddr; this.txtRemark.Text = model.Remark; this.txtStatus.Text = model.Status.ToString(); this.txtImagePath.Text = model.ImagePath; this.txtOperatorCode.Text = model.OperatorCode; this.txtNewNumber.Text = model.NewNumber.ToString(); this.txtNewMeterId.Text = model.NewMeterId.ToString(); this.txtInsertDate.Text = model.InsertDate.ToString(); this.txtChangeMeterDate.Text = model.ChangeMeterDate.ToString(); this.txtMeterID.Text = model.MeterID.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.ChangeMeterRegist GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UsersID,UserCode,OldNumber,NewMeterAddr,Remark,Status,ImagePath,OperatorCode,NewNumber,NewMeterId,InsertDate,ChangeMeterDate,MeterID from ChangeMeterRegist "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; WebDemo.Model.WebDemo.ChangeMeterRegist model = new WebDemo.Model.WebDemo.ChangeMeterRegist(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtUsersID.Text)) { strErr += "UsersID格式错误!\\n"; } if (this.txtUserCode.Text.Trim().Length == 0) { strErr += "UserCode不能为空!\\n"; } if (!PageValidate.IsDecimal(txtOldNumber.Text)) { strErr += "OldNumber格式错误!\\n"; } if (this.txtNewMeterAddr.Text.Trim().Length == 0) { strErr += "NewMeterAddr不能为空!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status格式错误!\\n"; } if (this.txtImagePath.Text.Trim().Length == 0) { strErr += "ImagePath不能为空!\\n"; } if (this.txtOperatorCode.Text.Trim().Length == 0) { strErr += "OperatorCode不能为空!\\n"; } if (!PageValidate.IsDecimal(txtNewNumber.Text)) { strErr += "NewNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtNewMeterId.Text)) { strErr += "NewMeterId格式错误!\\n"; } if (!PageValidate.IsDateTime(txtInsertDate.Text)) { strErr += "InsertDate格式错误!\\n"; } if (!PageValidate.IsDateTime(txtChangeMeterDate.Text)) { strErr += "ChangeMeterDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "MeterID格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ID = int.Parse(this.lblID.Text); int UsersID = int.Parse(this.txtUsersID.Text); string UserCode = this.txtUserCode.Text; decimal OldNumber = decimal.Parse(this.txtOldNumber.Text); string NewMeterAddr = this.txtNewMeterAddr.Text; string Remark = this.txtRemark.Text; int Status = int.Parse(this.txtStatus.Text); string ImagePath = this.txtImagePath.Text; string OperatorCode = this.txtOperatorCode.Text; decimal NewNumber = decimal.Parse(this.txtNewNumber.Text); int NewMeterId = int.Parse(this.txtNewMeterId.Text); DateTime InsertDate = DateTime.Parse(this.txtInsertDate.Text); DateTime ChangeMeterDate = DateTime.Parse(this.txtChangeMeterDate.Text); int MeterID = int.Parse(this.txtMeterID.Text); WebDemo.Model.WebDemo.ChangeMeterRegist model = new WebDemo.Model.WebDemo.ChangeMeterRegist(); model.ID = ID; model.UsersID = UsersID; model.UserCode = UserCode; model.OldNumber = OldNumber; model.NewMeterAddr = NewMeterAddr; model.Remark = Remark; model.Status = Status; model.ImagePath = ImagePath; model.OperatorCode = OperatorCode; model.NewNumber = NewNumber; model.NewMeterId = NewMeterId; model.InsertDate = InsertDate; model.ChangeMeterDate = ChangeMeterDate; model.MeterID = MeterID; WebDemo.BLL.WebDemo.ChangeMeterRegist bll = new WebDemo.BLL.WebDemo.ChangeMeterRegist(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.ChangeMeterRegist DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.ChangeMeterRegist model = new WebDemo.Model.WebDemo.ChangeMeterRegist(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["UsersID"] != null && row["UsersID"].ToString() != "") { model.UsersID = int.Parse(row["UsersID"].ToString()); } if (row["UserCode"] != null) { model.UserCode = row["UserCode"].ToString(); } if (row["OldNumber"] != null && row["OldNumber"].ToString() != "") { model.OldNumber = decimal.Parse(row["OldNumber"].ToString()); } if (row["NewMeterAddr"] != null) { model.NewMeterAddr = row["NewMeterAddr"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["ImagePath"] != null) { model.ImagePath = row["ImagePath"].ToString(); } if (row["OperatorCode"] != null) { model.OperatorCode = row["OperatorCode"].ToString(); } if (row["NewNumber"] != null && row["NewNumber"].ToString() != "") { model.NewNumber = decimal.Parse(row["NewNumber"].ToString()); } if (row["NewMeterId"] != null && row["NewMeterId"].ToString() != "") { model.NewMeterId = int.Parse(row["NewMeterId"].ToString()); } if (row["InsertDate"] != null && row["InsertDate"].ToString() != "") { model.InsertDate = DateTime.Parse(row["InsertDate"].ToString()); } if (row["ChangeMeterDate"] != null && row["ChangeMeterDate"].ToString() != "") { model.ChangeMeterDate = DateTime.Parse(row["ChangeMeterDate"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.ChangeMeterRegist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ChangeMeterRegist set "); strSql.Append("UsersID=@UsersID,"); strSql.Append("UserCode=@UserCode,"); strSql.Append("OldNumber=@OldNumber,"); strSql.Append("NewMeterAddr=@NewMeterAddr,"); strSql.Append("Remark=@Remark,"); strSql.Append("Status=@Status,"); strSql.Append("ImagePath=@ImagePath,"); strSql.Append("OperatorCode=@OperatorCode,"); strSql.Append("NewNumber=@NewNumber,"); strSql.Append("NewMeterId=@NewMeterId,"); strSql.Append("InsertDate=@InsertDate,"); strSql.Append("ChangeMeterDate=@ChangeMeterDate,"); strSql.Append("MeterID=@MeterID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UsersID", SqlDbType.Int, 4), new SqlParameter("@UserCode", SqlDbType.VarChar, 100), new SqlParameter("@OldNumber", SqlDbType.Decimal, 9), new SqlParameter("@NewMeterAddr", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@ImagePath", SqlDbType.VarChar, 8000), new SqlParameter("@OperatorCode", SqlDbType.VarChar, 100), new SqlParameter("@NewNumber", SqlDbType.Decimal, 9), new SqlParameter("@NewMeterId", SqlDbType.Int, 4), new SqlParameter("@InsertDate", SqlDbType.DateTime), new SqlParameter("@ChangeMeterDate", SqlDbType.DateTime), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UsersID; parameters[1].Value = model.UserCode; parameters[2].Value = model.OldNumber; parameters[3].Value = model.NewMeterAddr; parameters[4].Value = model.Remark; parameters[5].Value = model.Status; parameters[6].Value = model.ImagePath; parameters[7].Value = model.OperatorCode; parameters[8].Value = model.NewNumber; parameters[9].Value = model.NewMeterId; parameters[10].Value = model.InsertDate; parameters[11].Value = model.ChangeMeterDate; parameters[12].Value = model.MeterID; parameters[13].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }