/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Jium.Model.servicerorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into servicerorder(");
strSql.Append("ccode,spid,spnum,spspan,sostatus,createtime,updatetime,updateby,sos1,sos2,sos3,sos4,sos5,sod1,sod2,sod3,sod4,sod5)");
strSql.Append(" values (");
strSql.Append("@ccode,@spid,@spnum,@spspan,@sostatus,@createtime,@updatetime,@updateby,@sos1,@sos2,@sos3,@sos4,@sos5,@sod1,@sod2,@sod3,@sod4,@sod5)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ccode", MySqlDbType.VarChar, 40),
new MySqlParameter("@spid", MySqlDbType.VarChar, 20),
new MySqlParameter("@spnum", MySqlDbType.Int32, 11),
new MySqlParameter("@spspan", MySqlDbType.Int32, 11),
new MySqlParameter("@sostatus", MySqlDbType.Int32, 11),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updatetime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updateby", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos1", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos2", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos3", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos4", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos5", MySqlDbType.VarChar, 40),
new MySqlParameter("@sod1", MySqlDbType.Int32, 11),
new MySqlParameter("@sod2", MySqlDbType.Int32, 11),
new MySqlParameter("@sod3", MySqlDbType.Int32, 11),
new MySqlParameter("@sod4", MySqlDbType.Int32, 11),
new MySqlParameter("@sod5", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.ccode;
parameters[1].Value = model.spid;
parameters[2].Value = model.spnum;
parameters[3].Value = model.spspan;
parameters[4].Value = model.sostatus;
parameters[5].Value = model.createtime;
parameters[6].Value = model.updatetime;
parameters[7].Value = model.updateby;
parameters[8].Value = model.sos1;
parameters[9].Value = model.sos2;
parameters[10].Value = model.sos3;
parameters[11].Value = model.sos4;
parameters[12].Value = model.sos5;
parameters[13].Value = model.sod1;
parameters[14].Value = model.sod2;
parameters[15].Value = model.sod3;
parameters[16].Value = model.sod4;
parameters[17].Value = model.sod5;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.servicerorder GetModel(long id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,ccode,spid,spnum,spspan,sostatus,createtime,updatetime,updateby,sos1,sos2,sos3,sos4,sos5,sod1,sod2,sod3,sod4,sod5 from servicerorder ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int64)
};
parameters[0].Value = id;
Jium.Model.servicerorder model = new Jium.Model.servicerorder();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void ShowInfo(long id)
{
Jium.BLL.servicerorder bll = new Jium.BLL.servicerorder();
Jium.Model.servicerorder model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.txtccode.Text = model.ccode;
this.txtspid.Text = model.spid;
this.txtspnum.Text = model.spnum.ToString();
this.txtspspan.Text = model.spspan.ToString();
this.txtsostatus.Text = model.sostatus.ToString();
this.txtcreatetime.Text = model.createtime;
//this.txtupdatetime.Text=model.updatetime;
//this.txtupdateby.Text=model.updateby;
//this.txtsos1.Text=model.sos1;
//this.txtsos2.Text=model.sos2;
//this.txtsos3.Text=model.sos3;
//this.txtsos4.Text=model.sos4;
//this.txtsos5.Text=model.sos5;
//this.txtsod1.Text=model.sod1.ToString();
//this.txtsod2.Text=model.sod2.ToString();
//this.txtsod3.Text=model.sod3.ToString();
//this.txtsod4.Text=model.sod4.ToString();
//this.txtsod5.Text=model.sod5.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.servicerorder DataRowToModel(DataRow row)
{
Jium.Model.servicerorder model = new Jium.Model.servicerorder();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = long.Parse(row["id"].ToString());
}
if (row["ccode"] != null)
{
model.ccode = row["ccode"].ToString();
}
if (row["spid"] != null)
{
model.spid = row["spid"].ToString();
}
if (row["spnum"] != null && row["spnum"].ToString() != "")
{
model.spnum = int.Parse(row["spnum"].ToString());
}
if (row["spspan"] != null && row["spspan"].ToString() != "")
{
model.spspan = int.Parse(row["spspan"].ToString());
}
if (row["sostatus"] != null && row["sostatus"].ToString() != "")
{
model.sostatus = int.Parse(row["sostatus"].ToString());
}
if (row["createtime"] != null)
{
model.createtime = row["createtime"].ToString();
}
if (row["updatetime"] != null)
{
model.updatetime = row["updatetime"].ToString();
}
if (row["updateby"] != null)
{
model.updateby = row["updateby"].ToString();
}
if (row["sos1"] != null)
{
model.sos1 = row["sos1"].ToString();
}
if (row["sos2"] != null)
{
model.sos2 = row["sos2"].ToString();
}
if (row["sos3"] != null)
{
model.sos3 = row["sos3"].ToString();
}
if (row["sos4"] != null)
{
model.sos4 = row["sos4"].ToString();
}
if (row["sos5"] != null)
{
model.sos5 = row["sos5"].ToString();
}
if (row["sod1"] != null && row["sod1"].ToString() != "")
{
model.sod1 = int.Parse(row["sod1"].ToString());
}
if (row["sod2"] != null && row["sod2"].ToString() != "")
{
model.sod2 = int.Parse(row["sod2"].ToString());
}
if (row["sod3"] != null && row["sod3"].ToString() != "")
{
model.sod3 = int.Parse(row["sod3"].ToString());
}
if (row["sod4"] != null && row["sod4"].ToString() != "")
{
model.sod4 = int.Parse(row["sod4"].ToString());
}
if (row["sod5"] != null && row["sod5"].ToString() != "")
{
model.sod5 = int.Parse(row["sod5"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Jium.Model.servicerorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update servicerorder set ");
strSql.Append("ccode=@ccode,");
strSql.Append("spid=@spid,");
strSql.Append("spnum=@spnum,");
strSql.Append("spspan=@spspan,");
strSql.Append("sostatus=@sostatus,");
strSql.Append("createtime=@createtime,");
strSql.Append("updatetime=@updatetime,");
strSql.Append("updateby=@updateby,");
strSql.Append("sos1=@sos1,");
strSql.Append("sos2=@sos2,");
strSql.Append("sos3=@sos3,");
strSql.Append("sos4=@sos4,");
strSql.Append("sos5=@sos5,");
strSql.Append("sod1=@sod1,");
strSql.Append("sod2=@sod2,");
strSql.Append("sod3=@sod3,");
strSql.Append("sod4=@sod4,");
strSql.Append("sod5=@sod5");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@ccode", MySqlDbType.VarChar, 40),
new MySqlParameter("@spid", MySqlDbType.VarChar, 20),
new MySqlParameter("@spnum", MySqlDbType.Int32, 11),
new MySqlParameter("@spspan", MySqlDbType.Int32, 11),
new MySqlParameter("@sostatus", MySqlDbType.Int32, 11),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updatetime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updateby", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos1", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos2", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos3", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos4", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos5", MySqlDbType.VarChar, 40),
new MySqlParameter("@sod1", MySqlDbType.Int32, 11),
new MySqlParameter("@sod2", MySqlDbType.Int32, 11),
new MySqlParameter("@sod3", MySqlDbType.Int32, 11),
new MySqlParameter("@sod4", MySqlDbType.Int32, 11),
new MySqlParameter("@sod5", MySqlDbType.Int32, 11),
new MySqlParameter("@id", MySqlDbType.Int64, 20)
};
parameters[0].Value = model.ccode;
parameters[1].Value = model.spid;
parameters[2].Value = model.spnum;
parameters[3].Value = model.spspan;
parameters[4].Value = model.sostatus;
parameters[5].Value = model.createtime;
parameters[6].Value = model.updatetime;
parameters[7].Value = model.updateby;
parameters[8].Value = model.sos1;
parameters[9].Value = model.sos2;
parameters[10].Value = model.sos3;
parameters[11].Value = model.sos4;
parameters[12].Value = model.sos5;
parameters[13].Value = model.sod1;
parameters[14].Value = model.sod2;
parameters[15].Value = model.sod3;
parameters[16].Value = model.sod4;
parameters[17].Value = model.sod5;
parameters[18].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtccode.Text.Trim().Length == 0)
{
strErr += "ccode不能为空！\\n";
}
if (this.txtspid.Text.Trim().Length == 0)
{
strErr += "spid不能为空！\\n";
}
if (!PageValidate.IsNumber(txtspnum.Text))
{
strErr += "spnum格式错误！\\n";
}
if (!PageValidate.IsNumber(txtspspan.Text))
{
strErr += "spspan格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsostatus.Text))
{
strErr += "sostatus格式错误！\\n";
}
//if(this.txtcreatetime.Text.Trim().Length==0)
//{
// strErr+="createtime不能为空！\\n";
//}
//if(this.txtupdatetime.Text.Trim().Length==0)
//{
// strErr+="updatetime不能为空！\\n";
//}
//if(this.txtupdateby.Text.Trim().Length==0)
//{
// strErr+="updateby不能为空！\\n";
//}
//if(this.txtsos1.Text.Trim().Length==0)
//{
// strErr+="sos1不能为空！\\n";
//}
//if(this.txtsos2.Text.Trim().Length==0)
//{
// strErr+="sos2不能为空！\\n";
//}
//if(this.txtsos3.Text.Trim().Length==0)
//{
// strErr+="sos3不能为空！\\n";
//}
//if(this.txtsos4.Text.Trim().Length==0)
//{
// strErr+="sos4不能为空！\\n";
//}
//if(this.txtsos5.Text.Trim().Length==0)
//{
// strErr+="sos5不能为空！\\n";
//}
//if(!PageValidate.IsNumber(txtsod1.Text))
//{
// strErr+="sod1格式错误！\\n";
//}
//if(!PageValidate.IsNumber(txtsod2.Text))
//{
// strErr+="sod2格式错误！\\n";
//}
//if(!PageValidate.IsNumber(txtsod3.Text))
//{
// strErr+="sod3格式错误！\\n";
//}
//if(!PageValidate.IsNumber(txtsod4.Text))
//{
// strErr+="sod4格式错误！\\n";
//}
//if(!PageValidate.IsNumber(txtsod5.Text))
//{
// strErr+="sod5格式错误！\\n";
//}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
long id = long.Parse(this.lblid.Text);
string ccode = this.txtccode.Text;
string spid = this.txtspid.Text;
int spnum = int.Parse(this.txtspnum.Text);
int spspan = int.Parse(this.txtspspan.Text);
int sostatus = int.Parse(this.txtsostatus.Text);
string createtime = this.txtcreatetime.Text;
string updatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//string updateby=this.txtupdateby.Text;
//string sos1=this.txtsos1.Text;
//string sos2=this.txtsos2.Text;
//string sos3=this.txtsos3.Text;
//string sos4=this.txtsos4.Text;
//string sos5=this.txtsos5.Text;
//int sod1=int.Parse(this.txtsod1.Text);
//int sod2=int.Parse(this.txtsod2.Text);
//int sod3=int.Parse(this.txtsod3.Text);
//int sod4=int.Parse(this.txtsod4.Text);
//int sod5=int.Parse(this.txtsod5.Text);
Jium.Model.servicerorder model = new Jium.Model.servicerorder();
model.id = id;
model.ccode = ccode;
model.spid = spid;
model.spnum = spnum;
model.spspan = spspan;
model.sostatus = sostatus;
model.createtime = createtime;
model.updatetime = updatetime;
//model.updateby=updateby;
//model.sos1=sos1;
//model.sos2=sos2;
//model.sos3=sos3;
//model.sos4=sos4;
//model.sos5=sos5;
//model.sod1=sod1;
//model.sod2=sod2;
//model.sod3=sod3;
//model.sod4=sod4;
//model.sod5=sod5;
Jium.BLL.servicerorder bll = new Jium.BLL.servicerorder();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtccode.Text.Trim().Length == 0)
{
strErr += "ccode不能为空！\\n";
}
if (this.txtspid.Text.Trim().Length == 0)
{
strErr += "spid不能为空！\\n";
}
if (!PageValidate.IsNumber(txtspnum.Text))
{
strErr += "spnum格式错误！\\n";
}
if (!PageValidate.IsNumber(txtspspan.Text))
{
strErr += "spspan格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsostatus.Text))
{
strErr += "sostatus格式错误！\\n";
}
if (this.txtcreatetime.Text.Trim().Length == 0)
{
strErr += "createtime不能为空！\\n";
}
if (this.txtupdatetime.Text.Trim().Length == 0)
{
strErr += "updatetime不能为空！\\n";
}
if (this.txtupdateby.Text.Trim().Length == 0)
{
strErr += "updateby不能为空！\\n";
}
if (this.txtsos1.Text.Trim().Length == 0)
{
strErr += "sos1不能为空！\\n";
}
if (this.txtsos2.Text.Trim().Length == 0)
{
strErr += "sos2不能为空！\\n";
}
if (this.txtsos3.Text.Trim().Length == 0)
{
strErr += "sos3不能为空！\\n";
}
if (this.txtsos4.Text.Trim().Length == 0)
{
strErr += "sos4不能为空！\\n";
}
if (this.txtsos5.Text.Trim().Length == 0)
{
strErr += "sos5不能为空！\\n";
}
if (!PageValidate.IsNumber(txtsod1.Text))
{
strErr += "sod1格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsod2.Text))
{
strErr += "sod2格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsod3.Text))
{
strErr += "sod3格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsod4.Text))
{
strErr += "sod4格式错误！\\n";
}
if (!PageValidate.IsNumber(txtsod5.Text))
{
strErr += "sod5格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string ccode = this.txtccode.Text;
string spid = this.txtspid.Text;
int spnum = int.Parse(this.txtspnum.Text);
int spspan = int.Parse(this.txtspspan.Text);
int sostatus = int.Parse(this.txtsostatus.Text);
string createtime = this.txtcreatetime.Text;
string updatetime = this.txtupdatetime.Text;
string updateby = this.txtupdateby.Text;
string sos1 = this.txtsos1.Text;
string sos2 = this.txtsos2.Text;
string sos3 = this.txtsos3.Text;
string sos4 = this.txtsos4.Text;
string sos5 = this.txtsos5.Text;
int sod1 = int.Parse(this.txtsod1.Text);
int sod2 = int.Parse(this.txtsod2.Text);
int sod3 = int.Parse(this.txtsod3.Text);
int sod4 = int.Parse(this.txtsod4.Text);
int sod5 = int.Parse(this.txtsod5.Text);
Jium.Model.servicerorder model = new Jium.Model.servicerorder();
model.ccode = ccode;
model.spid = spid;
model.spnum = spnum;
model.spspan = spspan;
model.sostatus = sostatus;
model.createtime = createtime;
model.updatetime = updatetime;
model.updateby = updateby;
model.sos1 = sos1;
model.sos2 = sos2;
model.sos3 = sos3;
model.sos4 = sos4;
model.sos5 = sos5;
model.sod1 = sod1;
model.sod2 = sod2;
model.sod3 = sod3;
model.sod4 = sod4;
model.sod5 = sod5;
Jium.BLL.servicerorder bll = new Jium.BLL.servicerorder();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
