/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebDemo.Model.WebDemo.MeterRouteInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MeterRouteInfo(");
strSql.Append("MeterAddr,MeterNo,Node1,Depth1,Node2,Depth2,Node3,Depth3,Node4,Depth4,Result,CollectorId,MeterId,ReadTime)");
strSql.Append(" values (");
strSql.Append("@MeterAddr,@MeterNo,@Node1,@Depth1,@Node2,@Depth2,@Node3,@Depth3,@Node4,@Depth4,@Result,@CollectorId,@MeterId,@ReadTime)");
SqlParameter[] parameters =
{
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 20),
new SqlParameter("@MeterNo", SqlDbType.Int, 4),
new SqlParameter("@Node1", SqlDbType.VarChar, 20),
new SqlParameter("@Depth1", SqlDbType.Int, 4),
new SqlParameter("@Node2", SqlDbType.VarChar, 20),
new SqlParameter("@Depth2", SqlDbType.Int, 4),
new SqlParameter("@Node3", SqlDbType.VarChar, 20),
new SqlParameter("@Depth3", SqlDbType.Int, 4),
new SqlParameter("@Node4", SqlDbType.VarChar, 20),
new SqlParameter("@Depth4", SqlDbType.Int, 4),
new SqlParameter("@Result", SqlDbType.Bit, 1),
new SqlParameter("@CollectorId", SqlDbType.Int, 4),
new SqlParameter("@MeterId", SqlDbType.Int, 4),
new SqlParameter("@ReadTime", SqlDbType.DateTime)
};
parameters[0].Value = model.MeterAddr;
parameters[1].Value = model.MeterNo;
parameters[2].Value = model.Node1;
parameters[3].Value = model.Depth1;
parameters[4].Value = model.Node2;
parameters[5].Value = model.Depth2;
parameters[6].Value = model.Node3;
parameters[7].Value = model.Depth3;
parameters[8].Value = model.Node4;
parameters[9].Value = model.Depth4;
parameters[10].Value = model.Result;
parameters[11].Value = model.CollectorId;
parameters[12].Value = model.MeterId;
parameters[13].Value = model.ReadTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(string MeterAddr)
{
WebDemo.BLL.WebDemo.MeterRouteInfo bll = new WebDemo.BLL.WebDemo.MeterRouteInfo();
WebDemo.Model.WebDemo.MeterRouteInfo model = bll.GetModel(MeterAddr);
this.lblMeterAddr.Text = model.MeterAddr;
this.txtMeterNo.Text = model.MeterNo.ToString();
this.txtNode1.Text = model.Node1;
this.txtDepth1.Text = model.Depth1.ToString();
this.txtNode2.Text = model.Node2;
this.txtDepth2.Text = model.Depth2.ToString();
this.txtNode3.Text = model.Node3;
this.txtDepth3.Text = model.Depth3.ToString();
this.txtNode4.Text = model.Node4;
this.txtDepth4.Text = model.Depth4.ToString();
this.chkResult.Checked = model.Result;
this.txtCollectorId.Text = model.CollectorId.ToString();
this.txtMeterId.Text = model.MeterId.ToString();
this.txtReadTime.Text = model.ReadTime.ToString();
}
private void ShowInfo(string MeterAddr)
{
WebDemo.BLL.WebDemo.MeterRouteInfo bll = new WebDemo.BLL.WebDemo.MeterRouteInfo();
WebDemo.Model.WebDemo.MeterRouteInfo model = bll.GetModel(MeterAddr);
this.lblMeterAddr.Text = model.MeterAddr;
this.lblMeterNo.Text = model.MeterNo.ToString();
this.lblNode1.Text = model.Node1;
this.lblDepth1.Text = model.Depth1.ToString();
this.lblNode2.Text = model.Node2;
this.lblDepth2.Text = model.Depth2.ToString();
this.lblNode3.Text = model.Node3;
this.lblDepth3.Text = model.Depth3.ToString();
this.lblNode4.Text = model.Node4;
this.lblDepth4.Text = model.Depth4.ToString();
this.lblResult.Text = model.Result?"是":"否";
this.lblCollectorId.Text = model.CollectorId.ToString();
this.lblMeterId.Text = model.MeterId.ToString();
this.lblReadTime.Text = model.ReadTime.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MeterRouteInfo GetModel(string MeterAddr)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MeterAddr,MeterNo,Node1,Depth1,Node2,Depth2,Node3,Depth3,Node4,Depth4,Result,CollectorId,MeterId,ReadTime from MeterRouteInfo ");
strSql.Append(" where MeterAddr=@MeterAddr ");
SqlParameter[] parameters =
{
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 20)
};
parameters[0].Value = MeterAddr;
WebDemo.Model.WebDemo.MeterRouteInfo model = new WebDemo.Model.WebDemo.MeterRouteInfo();
DataSet ds = DbHelperSQL.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(WebDemo.Model.WebDemo.MeterRouteInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MeterRouteInfo set ");
strSql.Append("MeterNo=@MeterNo,");
strSql.Append("Node1=@Node1,");
strSql.Append("Depth1=@Depth1,");
strSql.Append("Node2=@Node2,");
strSql.Append("Depth2=@Depth2,");
strSql.Append("Node3=@Node3,");
strSql.Append("Depth3=@Depth3,");
strSql.Append("Node4=@Node4,");
strSql.Append("Depth4=@Depth4,");
strSql.Append("Result=@Result,");
strSql.Append("CollectorId=@CollectorId,");
strSql.Append("MeterId=@MeterId,");
strSql.Append("ReadTime=@ReadTime");
strSql.Append(" where MeterAddr=@MeterAddr ");
SqlParameter[] parameters =
{
new SqlParameter("@MeterNo", SqlDbType.Int, 4),
new SqlParameter("@Node1", SqlDbType.VarChar, 20),
new SqlParameter("@Depth1", SqlDbType.Int, 4),
new SqlParameter("@Node2", SqlDbType.VarChar, 20),
new SqlParameter("@Depth2", SqlDbType.Int, 4),
new SqlParameter("@Node3", SqlDbType.VarChar, 20),
new SqlParameter("@Depth3", SqlDbType.Int, 4),
new SqlParameter("@Node4", SqlDbType.VarChar, 20),
new SqlParameter("@Depth4", SqlDbType.Int, 4),
new SqlParameter("@Result", SqlDbType.Bit, 1),
new SqlParameter("@CollectorId", SqlDbType.Int, 4),
new SqlParameter("@MeterId", SqlDbType.Int, 4),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.MeterNo;
parameters[1].Value = model.Node1;
parameters[2].Value = model.Depth1;
parameters[3].Value = model.Node2;
parameters[4].Value = model.Depth2;
parameters[5].Value = model.Node3;
parameters[6].Value = model.Depth3;
parameters[7].Value = model.Node4;
parameters[8].Value = model.Depth4;
parameters[9].Value = model.Result;
parameters[10].Value = model.CollectorId;
parameters[11].Value = model.MeterId;
parameters[12].Value = model.ReadTime;
parameters[13].Value = model.MeterAddr;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.MeterRouteInfo DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.MeterRouteInfo model = new WebDemo.Model.WebDemo.MeterRouteInfo();
if (row != null)
{
if (row["MeterAddr"] != null)
{
model.MeterAddr = row["MeterAddr"].ToString();
}
if (row["MeterNo"] != null && row["MeterNo"].ToString() != "")
{
model.MeterNo = int.Parse(row["MeterNo"].ToString());
}
if (row["Node1"] != null)
{
model.Node1 = row["Node1"].ToString();
}
if (row["Depth1"] != null && row["Depth1"].ToString() != "")
{
model.Depth1 = int.Parse(row["Depth1"].ToString());
}
if (row["Node2"] != null)
{
model.Node2 = row["Node2"].ToString();
}
if (row["Depth2"] != null && row["Depth2"].ToString() != "")
{
model.Depth2 = int.Parse(row["Depth2"].ToString());
}
if (row["Node3"] != null)
{
model.Node3 = row["Node3"].ToString();
}
if (row["Depth3"] != null && row["Depth3"].ToString() != "")
{
model.Depth3 = int.Parse(row["Depth3"].ToString());
}
if (row["Node4"] != null)
{
model.Node4 = row["Node4"].ToString();
}
if (row["Depth4"] != null && row["Depth4"].ToString() != "")
{
model.Depth4 = int.Parse(row["Depth4"].ToString());
}
if (row["Result"] != null && row["Result"].ToString() != "")
{
if ((row["Result"].ToString() == "1") || (row["Result"].ToString().ToLower() == "true"))
{
model.Result = true;
}
else
{
model.Result = false;
}
}
if (row["CollectorId"] != null && row["CollectorId"].ToString() != "")
{
model.CollectorId = int.Parse(row["CollectorId"].ToString());
}
if (row["MeterId"] != null && row["MeterId"].ToString() != "")
{
model.MeterId = int.Parse(row["MeterId"].ToString());
}
if (row["ReadTime"] != null && row["ReadTime"].ToString() != "")
{
model.ReadTime = DateTime.Parse(row["ReadTime"].ToString());
}
}
return(model);
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtMeterNo.Text))
{
strErr += "MeterNo格式错误！\\n";
}
if (this.txtNode1.Text.Trim().Length == 0)
{
strErr += "Node1不能为空！\\n";
}
if (!PageValidate.IsNumber(txtDepth1.Text))
{
strErr += "Depth1格式错误！\\n";
}
if (this.txtNode2.Text.Trim().Length == 0)
{
strErr += "Node2不能为空！\\n";
}
if (!PageValidate.IsNumber(txtDepth2.Text))
{
strErr += "Depth2格式错误！\\n";
}
if (this.txtNode3.Text.Trim().Length == 0)
{
strErr += "Node3不能为空！\\n";
}
if (!PageValidate.IsNumber(txtDepth3.Text))
{
strErr += "Depth3格式错误！\\n";
}
if (this.txtNode4.Text.Trim().Length == 0)
{
strErr += "Node4不能为空！\\n";
}
if (!PageValidate.IsNumber(txtDepth4.Text))
{
strErr += "Depth4格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCollectorId.Text))
{
strErr += "CollectorId格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterId.Text))
{
strErr += "MeterId格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtReadTime.Text))
{
strErr += "ReadTime格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string MeterAddr = this.lblMeterAddr.Text;
int MeterNo = int.Parse(this.txtMeterNo.Text);
string Node1 = this.txtNode1.Text;
int Depth1 = int.Parse(this.txtDepth1.Text);
string Node2 = this.txtNode2.Text;
int Depth2 = int.Parse(this.txtDepth2.Text);
string Node3 = this.txtNode3.Text;
int Depth3 = int.Parse(this.txtDepth3.Text);
string Node4 = this.txtNode4.Text;
int Depth4 = int.Parse(this.txtDepth4.Text);
bool Result = this.chkResult.Checked;
int CollectorId = int.Parse(this.txtCollectorId.Text);
int MeterId = int.Parse(this.txtMeterId.Text);
DateTime ReadTime = DateTime.Parse(this.txtReadTime.Text);
WebDemo.Model.WebDemo.MeterRouteInfo model = new WebDemo.Model.WebDemo.MeterRouteInfo();
model.MeterAddr = MeterAddr;
model.MeterNo = MeterNo;
model.Node1 = Node1;
model.Depth1 = Depth1;
model.Node2 = Node2;
model.Depth2 = Depth2;
model.Node3 = Node3;
model.Depth3 = Depth3;
model.Node4 = Node4;
model.Depth4 = Depth4;
model.Result = Result;
model.CollectorId = CollectorId;
model.MeterId = MeterId;
model.ReadTime = ReadTime;
WebDemo.BLL.WebDemo.MeterRouteInfo bll = new WebDemo.BLL.WebDemo.MeterRouteInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}