/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_VEHICLE DataRowToModel(DataRow row) { MyERP.Model.PUB_VEHICLE model = new MyERP.Model.PUB_VEHICLE(); if (row != null) { if (row["VehicleID"] != null && row["VehicleID"].ToString() != "") { model.VehicleID = new Guid(row["VehicleID"].ToString()); } if (row["Vehicle_CODE"] != null) { model.Vehicle_CODE = row["Vehicle_CODE"].ToString(); } if (row["Vehicle_NAME"] != null) { model.Vehicle_NAME = row["Vehicle_NAME"].ToString(); } if (row["MobilePhone"] != null) { model.MobilePhone = row["MobilePhone"].ToString(); } if (row["standard_area"] != null && row["standard_area"].ToString() != "") { model.standard_area = decimal.Parse(row["standard_area"].ToString()); } if (row["Real_area"] != null && row["Real_area"].ToString() != "") { model.Real_area = decimal.Parse(row["Real_area"].ToString()); } if (row["weigth"] != null && row["weigth"].ToString() != "") { model.weigth = decimal.Parse(row["weigth"].ToString()); } if (row["Withcar"] != null) { model.Withcar = row["Withcar"].ToString(); } if (row["CREATE_DATE"] != null) { model.CREATE_DATE = row["CREATE_DATE"].ToString(); } if (row["CREATE_NAME"] != null) { model.CREATE_NAME = row["CREATE_NAME"].ToString(); } if (row["UPDATE_DATE"] != null && row["UPDATE_DATE"].ToString() != "") { model.UPDATE_DATE = DateTime.Parse(row["UPDATE_DATE"].ToString()); } if (row["UPDATE_NAME"] != null) { model.UPDATE_NAME = row["UPDATE_NAME"].ToString(); } if (row["REMARK"] != null) { model.REMARK = row["REMARK"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.PUB_VEHICLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PUB_VEHICLE set "); strSql.Append("VehicleID=@VehicleID,"); strSql.Append("Vehicle_NAME=@Vehicle_NAME,"); strSql.Append("MobilePhone=@MobilePhone,"); strSql.Append("standard_area=@standard_area,"); strSql.Append("Real_area=@Real_area,"); strSql.Append("weigth=@weigth,"); strSql.Append("Withcar=@Withcar,"); strSql.Append("CREATE_DATE=@CREATE_DATE,"); strSql.Append("CREATE_NAME=@CREATE_NAME,"); strSql.Append("UPDATE_DATE=@UPDATE_DATE,"); strSql.Append("UPDATE_NAME=@UPDATE_NAME,"); strSql.Append("REMARK=@REMARK"); strSql.Append(" where Vehicle_CODE=@Vehicle_CODE "); SqlParameter[] parameters = { new SqlParameter("@VehicleID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Vehicle_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 50), new SqlParameter("@standard_area", SqlDbType.Float, 8), new SqlParameter("@Real_area", SqlDbType.Float, 8), new SqlParameter("@weigth", SqlDbType.Float, 8), new SqlParameter("@Withcar", SqlDbType.NVarChar, 30), new SqlParameter("@CREATE_DATE", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_NAME", SqlDbType.NVarChar, 10), new SqlParameter("@UPDATE_DATE", SqlDbType.DateTime), new SqlParameter("@UPDATE_NAME", SqlDbType.NChar, 10), new SqlParameter("@REMARK", SqlDbType.VarChar, 50), new SqlParameter("@Vehicle_CODE", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.VehicleID; parameters[1].Value = model.Vehicle_NAME; parameters[2].Value = model.MobilePhone; parameters[3].Value = model.standard_area; parameters[4].Value = model.Real_area; parameters[5].Value = model.weigth; parameters[6].Value = model.Withcar; parameters[7].Value = model.CREATE_DATE; parameters[8].Value = model.CREATE_NAME; parameters[9].Value = model.UPDATE_DATE; parameters[10].Value = model.UPDATE_NAME; parameters[11].Value = model.REMARK; parameters[12].Value = model.Vehicle_CODE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.PUB_VEHICLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PUB_VEHICLE("); strSql.Append("VehicleID,Vehicle_CODE,Vehicle_NAME,MobilePhone,standard_area,Real_area,weigth,Withcar,CREATE_DATE,CREATE_NAME,UPDATE_DATE,UPDATE_NAME,REMARK)"); strSql.Append(" values ("); strSql.Append("@VehicleID,@Vehicle_CODE,@Vehicle_NAME,@MobilePhone,@standard_area,@Real_area,@weigth,@Withcar,@CREATE_DATE,@CREATE_NAME,@UPDATE_DATE,@UPDATE_NAME,@REMARK)"); SqlParameter[] parameters = { new SqlParameter("@VehicleID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Vehicle_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@Vehicle_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 50), new SqlParameter("@standard_area", SqlDbType.Float, 8), new SqlParameter("@Real_area", SqlDbType.Float, 8), new SqlParameter("@weigth", SqlDbType.Float, 8), new SqlParameter("@Withcar", SqlDbType.NVarChar, 30), new SqlParameter("@CREATE_DATE", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_NAME", SqlDbType.NVarChar, 10), new SqlParameter("@UPDATE_DATE", SqlDbType.DateTime), new SqlParameter("@UPDATE_NAME", SqlDbType.NChar, 10), new SqlParameter("@REMARK", SqlDbType.VarChar, 50) }; parameters[0].Value = Guid.NewGuid(); parameters[1].Value = model.Vehicle_CODE; parameters[2].Value = model.Vehicle_NAME; parameters[3].Value = model.MobilePhone; parameters[4].Value = model.standard_area; parameters[5].Value = model.Real_area; parameters[6].Value = model.weigth; parameters[7].Value = model.Withcar; parameters[8].Value = model.CREATE_DATE; parameters[9].Value = model.CREATE_NAME; parameters[10].Value = model.UPDATE_DATE; parameters[11].Value = model.UPDATE_NAME; parameters[12].Value = model.REMARK; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(string Vehicle_CODE) { MyERP.BLL.PUB_VEHICLE bll = new MyERP.BLL.PUB_VEHICLE(); MyERP.Model.PUB_VEHICLE model = bll.GetModel(Vehicle_CODE); this.lblVehicleID.Text = model.VehicleID.ToString(); this.lblVehicle_CODE.Text = model.Vehicle_CODE; this.lblVehicle_NAME.Text = model.Vehicle_NAME; this.lblMobilePhone.Text = model.MobilePhone; this.lblstandard_area.Text = model.standard_area.ToString(); this.lblReal_area.Text = model.Real_area.ToString(); this.lblweigth.Text = model.weigth.ToString(); this.lblWithcar.Text = model.Withcar; this.lblCREATE_DATE.Text = model.CREATE_DATE; this.lblCREATE_NAME.Text = model.CREATE_NAME; this.lblUPDATE_DATE.Text = model.UPDATE_DATE.ToString(); this.lblUPDATE_NAME.Text = model.UPDATE_NAME; this.lblREMARK.Text = model.REMARK; }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_VEHICLE GetModel(string Vehicle_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 VehicleID,Vehicle_CODE,Vehicle_NAME,MobilePhone,standard_area,Real_area,weigth,Withcar,CREATE_DATE,CREATE_NAME,UPDATE_DATE,UPDATE_NAME,REMARK from PUB_VEHICLE "); strSql.Append(" where Vehicle_CODE=@Vehicle_CODE "); SqlParameter[] parameters = { new SqlParameter("@Vehicle_CODE", SqlDbType.NVarChar, 50) }; parameters[0].Value = Vehicle_CODE; MyERP.Model.PUB_VEHICLE model = new MyERP.Model.PUB_VEHICLE(); 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 (this.txtVehicle_NAME.Text.Trim().Length == 0) { strErr += "Vehicle_NAME不能为空!\\n"; } if (this.txtMobilePhone.Text.Trim().Length == 0) { strErr += "MobilePhone不能为空!\\n"; } if (!PageValidate.IsDecimal(txtstandard_area.Text)) { strErr += "standard_area格式错误!\\n"; } if (!PageValidate.IsDecimal(txtReal_area.Text)) { strErr += "Real_area格式错误!\\n"; } if (!PageValidate.IsDecimal(txtweigth.Text)) { strErr += "weigth格式错误!\\n"; } if (this.txtWithcar.Text.Trim().Length == 0) { strErr += "Withcar不能为空!\\n"; } if (this.txtCREATE_DATE.Text.Trim().Length == 0) { strErr += "CREATE_DATE不能为空!\\n"; } if (this.txtCREATE_NAME.Text.Trim().Length == 0) { strErr += "CREATE_NAME不能为空!\\n"; } if (!PageValidate.IsDateTime(txtUPDATE_DATE.Text)) { strErr += "UPDATE_DATE格式错误!\\n"; } if (this.txtUPDATE_NAME.Text.Trim().Length == 0) { strErr += "UPDATE_NAME不能为空!\\n"; } if (this.txtREMARK.Text.Trim().Length == 0) { strErr += "REMARK不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } Guid VehicleID = new Guid(this.lblVehicleID.Text); string Vehicle_CODE = this.lblVehicle_CODE.Text; string Vehicle_NAME = this.txtVehicle_NAME.Text; string MobilePhone = this.txtMobilePhone.Text; decimal standard_area = decimal.Parse(this.txtstandard_area.Text); decimal Real_area = decimal.Parse(this.txtReal_area.Text); decimal weigth = decimal.Parse(this.txtweigth.Text); string Withcar = this.txtWithcar.Text; string CREATE_DATE = this.txtCREATE_DATE.Text; string CREATE_NAME = this.txtCREATE_NAME.Text; DateTime UPDATE_DATE = DateTime.Parse(this.txtUPDATE_DATE.Text); string UPDATE_NAME = this.txtUPDATE_NAME.Text; string REMARK = this.txtREMARK.Text; MyERP.Model.PUB_VEHICLE model = new MyERP.Model.PUB_VEHICLE(); model.VehicleID = VehicleID; model.Vehicle_CODE = Vehicle_CODE; model.Vehicle_NAME = Vehicle_NAME; model.MobilePhone = MobilePhone; model.standard_area = standard_area; model.Real_area = Real_area; model.weigth = weigth; model.Withcar = Withcar; model.CREATE_DATE = CREATE_DATE; model.CREATE_NAME = CREATE_NAME; model.UPDATE_DATE = UPDATE_DATE; model.UPDATE_NAME = UPDATE_NAME; model.REMARK = REMARK; MyERP.BLL.PUB_VEHICLE bll = new MyERP.BLL.PUB_VEHICLE(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }