/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bsam.Core.Model.Models.Model.Inv_District model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Inv_District("); strSql.Append("Id,DistrictCode,DistrictName,DistrictDesc,DistrictStatus,Volume,VolumeUnit,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId,InvId)"); strSql.Append(" values ("); strSql.Append("@Id,@DistrictCode,@DistrictName,@DistrictDesc,@DistrictStatus,@Volume,@VolumeUnit,@DateTimeCreated,@UserCreator,@DateTimeModified,@UserModified,@State,@OrgId,@InvId)"); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8), new SQLiteParameter("@DistrictCode", DbType.String, 0), new SQLiteParameter("@DistrictName", DbType.String, 0), new SQLiteParameter("@DistrictDesc", DbType.String, 0), new SQLiteParameter("@DistrictStatus", DbType.String, 0), new SQLiteParameter("@Volume", DbType.Int32, 4), new SQLiteParameter("@VolumeUnit", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0), new SQLiteParameter("@InvId", DbType.Int32, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.DistrictCode; parameters[2].Value = model.DistrictName; parameters[3].Value = model.DistrictDesc; parameters[4].Value = model.DistrictStatus; parameters[5].Value = model.Volume; parameters[6].Value = model.VolumeUnit; parameters[7].Value = model.DateTimeCreated; parameters[8].Value = model.UserCreator; parameters[9].Value = model.DateTimeModified; parameters[10].Value = model.UserModified; parameters[11].Value = model.State; parameters[12].Value = model.OrgId; parameters[13].Value = model.InvId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo() { Bsam.Core.Model.Models.BLL.Inv_District bll = new Bsam.Core.Model.Models.BLL.Inv_District(); Bsam.Core.Model.Models.Model.Inv_District model = bll.GetModel(); this.lblId.Text = model.Id.ToString(); this.lblDistrictCode.Text = model.DistrictCode; this.lblDistrictName.Text = model.DistrictName; this.lblDistrictDesc.Text = model.DistrictDesc; this.lblDistrictStatus.Text = model.DistrictStatus; this.lblVolume.Text = model.Volume.ToString(); this.lblVolumeUnit.Text = model.VolumeUnit; this.lblDateTimeCreated.Text = model.DateTimeCreated.ToString(); this.lblUserCreator.Text = model.UserCreator; this.lblDateTimeModified.Text = model.DateTimeModified.ToString(); this.lblUserModified.Text = model.UserModified; this.lblState.Text = model.State?"是":"否"; this.lblOrgId.Text = model.OrgId; this.lblInvId.Text = model.InvId.ToString(); }
private void ShowInfo() { Bsam.Core.Model.Models.BLL.Inv_District bll = new Bsam.Core.Model.Models.BLL.Inv_District(); Bsam.Core.Model.Models.Model.Inv_District model = bll.GetModel(); this.txtId.Text = model.Id.ToString(); this.txtDistrictCode.Text = model.DistrictCode; this.txtDistrictName.Text = model.DistrictName; this.txtDistrictDesc.Text = model.DistrictDesc; this.txtDistrictStatus.Text = model.DistrictStatus; this.txtVolume.Text = model.Volume.ToString(); this.txtVolumeUnit.Text = model.VolumeUnit; this.txtDateTimeCreated.Text = model.DateTimeCreated.ToString(); this.txtUserCreator.Text = model.UserCreator; this.txtDateTimeModified.Text = model.DateTimeModified.ToString(); this.txtUserModified.Text = model.UserModified; this.chkState.Checked = model.State; this.txtOrgId.Text = model.OrgId; this.txtInvId.Text = model.InvId.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Bsam.Core.Model.Models.Model.Inv_District GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,DistrictCode,DistrictName,DistrictDesc,DistrictStatus,Volume,VolumeUnit,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId,InvId from Inv_District "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Inv_District model = new Bsam.Core.Model.Models.Model.Inv_District(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Inv_District model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Inv_District set "); strSql.Append("Id=@Id,"); strSql.Append("DistrictCode=@DistrictCode,"); strSql.Append("DistrictName=@DistrictName,"); strSql.Append("DistrictDesc=@DistrictDesc,"); strSql.Append("DistrictStatus=@DistrictStatus,"); strSql.Append("Volume=@Volume,"); strSql.Append("VolumeUnit=@VolumeUnit,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State,"); strSql.Append("OrgId=@OrgId,"); strSql.Append("InvId=@InvId"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8), new SQLiteParameter("@DistrictCode", DbType.String, 0), new SQLiteParameter("@DistrictName", DbType.String, 0), new SQLiteParameter("@DistrictDesc", DbType.String, 0), new SQLiteParameter("@DistrictStatus", DbType.String, 0), new SQLiteParameter("@Volume", DbType.Int32, 4), new SQLiteParameter("@VolumeUnit", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0), new SQLiteParameter("@InvId", DbType.Int32, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.DistrictCode; parameters[2].Value = model.DistrictName; parameters[3].Value = model.DistrictDesc; parameters[4].Value = model.DistrictStatus; parameters[5].Value = model.Volume; parameters[6].Value = model.VolumeUnit; parameters[7].Value = model.DateTimeCreated; parameters[8].Value = model.UserCreator; parameters[9].Value = model.DateTimeModified; parameters[10].Value = model.UserModified; parameters[11].Value = model.State; parameters[12].Value = model.OrgId; parameters[13].Value = model.InvId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Bsam.Core.Model.Models.Model.Inv_District DataRowToModel(DataRow row) { Bsam.Core.Model.Models.Model.Inv_District model = new Bsam.Core.Model.Models.Model.Inv_District(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["DistrictCode"] != null) { model.DistrictCode = row["DistrictCode"].ToString(); } if (row["DistrictName"] != null) { model.DistrictName = row["DistrictName"].ToString(); } if (row["DistrictDesc"] != null) { model.DistrictDesc = row["DistrictDesc"].ToString(); } if (row["DistrictStatus"] != null) { model.DistrictStatus = row["DistrictStatus"].ToString(); } if (row["Volume"] != null && row["Volume"].ToString() != "") { model.Volume = int.Parse(row["Volume"].ToString()); } if (row["VolumeUnit"] != null) { model.VolumeUnit = row["VolumeUnit"].ToString(); } if (row["DateTimeCreated"] != null && row["DateTimeCreated"].ToString() != "") { model.DateTimeCreated = DateTime.Parse(row["DateTimeCreated"].ToString()); } if (row["UserCreator"] != null) { model.UserCreator = row["UserCreator"].ToString(); } if (row["DateTimeModified"] != null && row["DateTimeModified"].ToString() != "") { model.DateTimeModified = DateTime.Parse(row["DateTimeModified"].ToString()); } if (row["UserModified"] != null) { model.UserModified = row["UserModified"].ToString(); } if (row["State"] != null && row["State"].ToString() != "") { if ((row["State"].ToString() == "1") || (row["State"].ToString().ToLower() == "true")) { model.State = true; } else { model.State = false; } } if (row["OrgId"] != null) { model.OrgId = row["OrgId"].ToString(); } if (row["InvId"] != null && row["InvId"].ToString() != "") { model.InvId = int.Parse(row["InvId"].ToString()); } } return(model); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtId.Text)) { strErr += "Id格式错误!\\n"; } if (this.txtDistrictCode.Text.Trim().Length == 0) { strErr += "DistrictCode不能为空!\\n"; } if (this.txtDistrictName.Text.Trim().Length == 0) { strErr += "DistrictName不能为空!\\n"; } if (this.txtDistrictDesc.Text.Trim().Length == 0) { strErr += "DistrictDesc不能为空!\\n"; } if (this.txtDistrictStatus.Text.Trim().Length == 0) { strErr += "DistrictStatus不能为空!\\n"; } if (!PageValidate.IsNumber(txtVolume.Text)) { strErr += "Volume格式错误!\\n"; } if (this.txtVolumeUnit.Text.Trim().Length == 0) { strErr += "VolumeUnit不能为空!\\n"; } if (!PageValidate.IsDateTime(txtDateTimeCreated.Text)) { strErr += "DateTimeCreated格式错误!\\n"; } if (this.txtUserCreator.Text.Trim().Length == 0) { strErr += "UserCreator不能为空!\\n"; } if (!PageValidate.IsDateTime(txtDateTimeModified.Text)) { strErr += "DateTimeModified格式错误!\\n"; } if (this.txtUserModified.Text.Trim().Length == 0) { strErr += "UserModified不能为空!\\n"; } if (this.txtOrgId.Text.Trim().Length == 0) { strErr += "OrgId不能为空!\\n"; } if (!PageValidate.IsNumber(txtInvId.Text)) { strErr += "InvId格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Id = int.Parse(this.txtId.Text); string DistrictCode = this.txtDistrictCode.Text; string DistrictName = this.txtDistrictName.Text; string DistrictDesc = this.txtDistrictDesc.Text; string DistrictStatus = this.txtDistrictStatus.Text; int Volume = int.Parse(this.txtVolume.Text); string VolumeUnit = this.txtVolumeUnit.Text; DateTime DateTimeCreated = DateTime.Parse(this.txtDateTimeCreated.Text); string UserCreator = this.txtUserCreator.Text; DateTime DateTimeModified = DateTime.Parse(this.txtDateTimeModified.Text); string UserModified = this.txtUserModified.Text; bool State = this.chkState.Checked; string OrgId = this.txtOrgId.Text; int InvId = int.Parse(this.txtInvId.Text); Bsam.Core.Model.Models.Model.Inv_District model = new Bsam.Core.Model.Models.Model.Inv_District(); model.Id = Id; model.DistrictCode = DistrictCode; model.DistrictName = DistrictName; model.DistrictDesc = DistrictDesc; model.DistrictStatus = DistrictStatus; model.Volume = Volume; model.VolumeUnit = VolumeUnit; model.DateTimeCreated = DateTimeCreated; model.UserCreator = UserCreator; model.DateTimeModified = DateTimeModified; model.UserModified = UserModified; model.State = State; model.OrgId = OrgId; model.InvId = InvId; Bsam.Core.Model.Models.BLL.Inv_District bll = new Bsam.Core.Model.Models.BLL.Inv_District(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }