/// <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");
}
