/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.InstantTask model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update InstantTask set ");
strSql.Append("TaskType=@TaskType,");
strSql.Append("CollectorID=@CollectorID,");
strSql.Append("MeterType=@MeterType,");
strSql.Append("MeterAddr=@MeterAddr,");
strSql.Append("HostAddr=@HostAddr,");
strSql.Append("MeterStatus=@MeterStatus,");
strSql.Append("MeterData=@MeterData,");
strSql.Append("PayMoney=@PayMoney,");
strSql.Append("TotalPayMoney=@TotalPayMoney");
strSql.Append(" where TaskID=@TaskID ");
SqlParameter[] parameters =
{
new SqlParameter("@TaskType", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorID", SqlDbType.Int, 4),
new SqlParameter("@MeterType", SqlDbType.Int, 4),
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 12),
new SqlParameter("@HostAddr", SqlDbType.VarChar, 12),
new SqlParameter("@MeterStatus", SqlDbType.Int, 4),
new SqlParameter("@MeterData", SqlDbType.Int, 4),
new SqlParameter("@PayMoney", SqlDbType.VarChar, 50),
new SqlParameter("@TotalPayMoney", SqlDbType.VarChar, 50),
new SqlParameter("@TaskID", SqlDbType.Int, 4)
};
parameters[0].Value = model.TaskType;
parameters[1].Value = model.CollectorID;
parameters[2].Value = model.MeterType;
parameters[3].Value = model.MeterAddr;
parameters[4].Value = model.HostAddr;
parameters[5].Value = model.MeterStatus;
parameters[6].Value = model.MeterData;
parameters[7].Value = model.PayMoney;
parameters[8].Value = model.TotalPayMoney;
parameters[9].Value = model.TaskID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int TaskID)
{
WebDemo.BLL.WebDemo.InstantTask bll = new WebDemo.BLL.WebDemo.InstantTask();
WebDemo.Model.WebDemo.InstantTask model = bll.GetModel(TaskID);
this.lblTaskID.Text = model.TaskID.ToString();
this.lblTaskType.Text = model.TaskType;
this.lblCollectorID.Text = model.CollectorID.ToString();
this.lblMeterType.Text = model.MeterType.ToString();
this.lblMeterAddr.Text = model.MeterAddr;
this.lblHostAddr.Text = model.HostAddr;
this.lblMeterStatus.Text = model.MeterStatus.ToString();
this.lblMeterData.Text = model.MeterData.ToString();
this.lblPayMoney.Text = model.PayMoney;
this.lblTotalPayMoney.Text = model.TotalPayMoney;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.InstantTask DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.InstantTask model = new WebDemo.Model.WebDemo.InstantTask();
if (row != null)
{
if (row["TaskID"] != null && row["TaskID"].ToString() != "")
{
model.TaskID = int.Parse(row["TaskID"].ToString());
}
if (row["TaskType"] != null)
{
model.TaskType = row["TaskType"].ToString();
}
if (row["CollectorID"] != null && row["CollectorID"].ToString() != "")
{
model.CollectorID = int.Parse(row["CollectorID"].ToString());
}
if (row["MeterType"] != null && row["MeterType"].ToString() != "")
{
model.MeterType = int.Parse(row["MeterType"].ToString());
}
if (row["MeterAddr"] != null)
{
model.MeterAddr = row["MeterAddr"].ToString();
}
if (row["HostAddr"] != null)
{
model.HostAddr = row["HostAddr"].ToString();
}
if (row["MeterStatus"] != null && row["MeterStatus"].ToString() != "")
{
model.MeterStatus = int.Parse(row["MeterStatus"].ToString());
}
if (row["MeterData"] != null && row["MeterData"].ToString() != "")
{
model.MeterData = int.Parse(row["MeterData"].ToString());
}
if (row["PayMoney"] != null)
{
model.PayMoney = row["PayMoney"].ToString();
}
if (row["TotalPayMoney"] != null)
{
model.TotalPayMoney = row["TotalPayMoney"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebDemo.Model.WebDemo.InstantTask model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into InstantTask(");
strSql.Append("TaskID,TaskType,CollectorID,MeterType,MeterAddr,HostAddr,MeterStatus,MeterData,PayMoney,TotalPayMoney)");
strSql.Append(" values (");
strSql.Append("@TaskID,@TaskType,@CollectorID,@MeterType,@MeterAddr,@HostAddr,@MeterStatus,@MeterData,@PayMoney,@TotalPayMoney)");
SqlParameter[] parameters =
{
new SqlParameter("@TaskID", SqlDbType.Int, 4),
new SqlParameter("@TaskType", SqlDbType.VarChar, 50),
new SqlParameter("@CollectorID", SqlDbType.Int, 4),
new SqlParameter("@MeterType", SqlDbType.Int, 4),
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 12),
new SqlParameter("@HostAddr", SqlDbType.VarChar, 12),
new SqlParameter("@MeterStatus", SqlDbType.Int, 4),
new SqlParameter("@MeterData", SqlDbType.Int, 4),
new SqlParameter("@PayMoney", SqlDbType.VarChar, 50),
new SqlParameter("@TotalPayMoney", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.TaskID;
parameters[1].Value = model.TaskType;
parameters[2].Value = model.CollectorID;
parameters[3].Value = model.MeterType;
parameters[4].Value = model.MeterAddr;
parameters[5].Value = model.HostAddr;
parameters[6].Value = model.MeterStatus;
parameters[7].Value = model.MeterData;
parameters[8].Value = model.PayMoney;
parameters[9].Value = model.TotalPayMoney;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.InstantTask GetModel(int TaskID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TaskID,TaskType,CollectorID,MeterType,MeterAddr,HostAddr,MeterStatus,MeterData,PayMoney,TotalPayMoney from InstantTask ");
strSql.Append(" where TaskID=@TaskID ");
SqlParameter[] parameters =
{
new SqlParameter("@TaskID", SqlDbType.Int, 4)
};
parameters[0].Value = TaskID;
WebDemo.Model.WebDemo.InstantTask model = new WebDemo.Model.WebDemo.InstantTask();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtTaskID.Text))
{
strErr += "TaskID格式错误！\\n";
}
if (this.txtTaskType.Text.Trim().Length == 0)
{
strErr += "TaskType不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCollectorID.Text))
{
strErr += "CollectorID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterType.Text))
{
strErr += "MeterType格式错误！\\n";
}
if (this.txtMeterAddr.Text.Trim().Length == 0)
{
strErr += "MeterAddr不能为空！\\n";
}
if (this.txtHostAddr.Text.Trim().Length == 0)
{
strErr += "HostAddr不能为空！\\n";
}
if (!PageValidate.IsNumber(txtMeterStatus.Text))
{
strErr += "MeterStatus格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterData.Text))
{
strErr += "MeterData格式错误！\\n";
}
if (this.txtPayMoney.Text.Trim().Length == 0)
{
strErr += "本次购买量不能为空！\\n";
}
if (this.txtTotalPayMoney.Text.Trim().Length == 0)
{
strErr += "总量不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int TaskID = int.Parse(this.txtTaskID.Text);
string TaskType = this.txtTaskType.Text;
int CollectorID = int.Parse(this.txtCollectorID.Text);
int MeterType = int.Parse(this.txtMeterType.Text);
string MeterAddr = this.txtMeterAddr.Text;
string HostAddr = this.txtHostAddr.Text;
int MeterStatus = int.Parse(this.txtMeterStatus.Text);
int MeterData = int.Parse(this.txtMeterData.Text);
string PayMoney = this.txtPayMoney.Text;
string TotalPayMoney = this.txtTotalPayMoney.Text;
WebDemo.Model.WebDemo.InstantTask model = new WebDemo.Model.WebDemo.InstantTask();
model.TaskID = TaskID;
model.TaskType = TaskType;
model.CollectorID = CollectorID;
model.MeterType = MeterType;
model.MeterAddr = MeterAddr;
model.HostAddr = HostAddr;
model.MeterStatus = MeterStatus;
model.MeterData = MeterData;
model.PayMoney = PayMoney;
model.TotalPayMoney = TotalPayMoney;
WebDemo.BLL.WebDemo.InstantTask bll = new WebDemo.BLL.WebDemo.InstantTask();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
