private void ShowInfo()
{
WebDemo.BLL.WebDemo.TaskPlanHistory bll = new WebDemo.BLL.WebDemo.TaskPlanHistory();
WebDemo.Model.WebDemo.TaskPlanHistory model = bll.GetModel();
this.txtID.Text = model.ID.ToString();
this.txtTaskID.Text = model.TaskID.ToString();
this.txtCollectorID.Text = model.CollectorID.ToString();
this.txtTaskName.Text = model.TaskName;
this.txtCommandID.Text = model.CommandID.ToString();
this.txtCommandInfo.Text = model.CommandInfo;
this.txtMeterAddr.Text = model.MeterAddr;
this.txtMeterType.Text = model.MeterType.ToString();
this.txtMeterItem.Text = model.MeterItem.ToString();
this.txtFreezeDate.Text = model.FreezeDate;
this.txtTaskMonth.Text = model.TaskMonth.ToString();
this.txtTaskDay.Text = model.TaskDay.ToString();
this.txtTaskHour.Text = model.TaskHour.ToString();
this.txtTaskMinute.Text = model.TaskMinute.ToString();
this.txtExeMark.Text = model.ExeMark.ToString();
this.txtExeDate.Text = model.ExeDate.ToString();
this.txtExeError.Text = model.ExeError.ToString();
this.txtTaskMark.Text = model.TaskMark.ToString();
this.txtTaskType.Text = model.TaskType.ToString();
this.txtTaskError.Text = model.TaskError.ToString();
this.txtTryNum.Text = model.TryNum.ToString();
this.txtHostAddr.Text = model.HostAddr;
this.txtInsDate.Text = model.InsDate.ToString();
this.txtMeterID.Text = model.MeterID.ToString();
this.txtTaskFrequency.Text = model.TaskFrequency.ToString();
this.txtExeInfo.Text = model.ExeInfo;
this.txtOperatorID.Text = model.OperatorID.ToString();
this.txtDeptID.Text = model.DeptID;
this.txtTaskWeek.Text = model.TaskWeek.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.TaskPlanHistory GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,TaskID,CollectorID,TaskName,CommandID,CommandInfo,MeterAddr,MeterType,MeterItem,FreezeDate,TaskMonth,TaskDay,TaskHour,TaskMinute,ExeMark,ExeDate,ExeError,TaskMark,TaskType,TaskError,TryNum,HostAddr,InsDate,MeterID,TaskFrequency,ExeInfo,OperatorID,DeptID,TaskWeek from TaskPlanHistory ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
WebDemo.Model.WebDemo.TaskPlanHistory model = new WebDemo.Model.WebDemo.TaskPlanHistory();
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 (!PageValidate.IsNumber(txtID.Text))
{
strErr += "ID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskID.Text))
{
strErr += "TaskID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCollectorID.Text))
{
strErr += "CollectorID格式错误！\\n";
}
if (this.txtTaskName.Text.Trim().Length == 0)
{
strErr += "TaskName不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCommandID.Text))
{
strErr += "CommandID格式错误！\\n";
}
if (this.txtCommandInfo.Text.Trim().Length == 0)
{
strErr += "CommandInfo不能为空！\\n";
}
if (this.txtMeterAddr.Text.Trim().Length == 0)
{
strErr += "MeterAddr不能为空！\\n";
}
if (!PageValidate.IsNumber(txtMeterType.Text))
{
strErr += "MeterType格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterItem.Text))
{
strErr += "MeterItem格式错误！\\n";
}
if (this.txtFreezeDate.Text.Trim().Length == 0)
{
strErr += "FreezeDate不能为空！\\n";
}
if (!PageValidate.IsNumber(txtTaskMonth.Text))
{
strErr += "TaskMonth格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskDay.Text))
{
strErr += "TaskDay格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskHour.Text))
{
strErr += "TaskHour格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskMinute.Text))
{
strErr += "TaskMinute格式错误！\\n";
}
if (!PageValidate.IsNumber(txtExeMark.Text))
{
strErr += "ExeMark格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtExeDate.Text))
{
strErr += "ExeDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtExeError.Text))
{
strErr += "ExeError格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskMark.Text))
{
strErr += "TaskMark格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskType.Text))
{
strErr += "TaskType格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskError.Text))
{
strErr += "TaskError格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTryNum.Text))
{
strErr += "TryNum格式错误！\\n";
}
if (this.txtHostAddr.Text.Trim().Length == 0)
{
strErr += "HostAddr不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtInsDate.Text))
{
strErr += "InsDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterID.Text))
{
strErr += "MeterID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskFrequency.Text))
{
strErr += "TaskFrequency格式错误！\\n";
}
if (this.txtExeInfo.Text.Trim().Length == 0)
{
strErr += "ExeInfo不能为空！\\n";
}
if (!PageValidate.IsNumber(txtOperatorID.Text))
{
strErr += "OperatorID格式错误！\\n";
}
if (this.txtDeptID.Text.Trim().Length == 0)
{
strErr += "DeptID不能为空！\\n";
}
if (!PageValidate.IsNumber(txtTaskWeek.Text))
{
strErr += "TaskWeek格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int ID = int.Parse(this.txtID.Text);
int TaskID = int.Parse(this.txtTaskID.Text);
int CollectorID = int.Parse(this.txtCollectorID.Text);
string TaskName = this.txtTaskName.Text;
int CommandID = int.Parse(this.txtCommandID.Text);
string CommandInfo = this.txtCommandInfo.Text;
string MeterAddr = this.txtMeterAddr.Text;
int MeterType = int.Parse(this.txtMeterType.Text);
int MeterItem = int.Parse(this.txtMeterItem.Text);
string FreezeDate = this.txtFreezeDate.Text;
int TaskMonth = int.Parse(this.txtTaskMonth.Text);
int TaskDay = int.Parse(this.txtTaskDay.Text);
int TaskHour = int.Parse(this.txtTaskHour.Text);
int TaskMinute = int.Parse(this.txtTaskMinute.Text);
int ExeMark = int.Parse(this.txtExeMark.Text);
DateTime ExeDate = DateTime.Parse(this.txtExeDate.Text);
int ExeError = int.Parse(this.txtExeError.Text);
int TaskMark = int.Parse(this.txtTaskMark.Text);
int TaskType = int.Parse(this.txtTaskType.Text);
int TaskError = int.Parse(this.txtTaskError.Text);
int TryNum = int.Parse(this.txtTryNum.Text);
string HostAddr = this.txtHostAddr.Text;
DateTime InsDate = DateTime.Parse(this.txtInsDate.Text);
int MeterID = int.Parse(this.txtMeterID.Text);
int TaskFrequency = int.Parse(this.txtTaskFrequency.Text);
string ExeInfo = this.txtExeInfo.Text;
int OperatorID = int.Parse(this.txtOperatorID.Text);
string DeptID = this.txtDeptID.Text;
int TaskWeek = int.Parse(this.txtTaskWeek.Text);
WebDemo.Model.WebDemo.TaskPlanHistory model = new WebDemo.Model.WebDemo.TaskPlanHistory();
model.ID = ID;
model.TaskID = TaskID;
model.CollectorID = CollectorID;
model.TaskName = TaskName;
model.CommandID = CommandID;
model.CommandInfo = CommandInfo;
model.MeterAddr = MeterAddr;
model.MeterType = MeterType;
model.MeterItem = MeterItem;
model.FreezeDate = FreezeDate;
model.TaskMonth = TaskMonth;
model.TaskDay = TaskDay;
model.TaskHour = TaskHour;
model.TaskMinute = TaskMinute;
model.ExeMark = ExeMark;
model.ExeDate = ExeDate;
model.ExeError = ExeError;
model.TaskMark = TaskMark;
model.TaskType = TaskType;
model.TaskError = TaskError;
model.TryNum = TryNum;
model.HostAddr = HostAddr;
model.InsDate = InsDate;
model.MeterID = MeterID;
model.TaskFrequency = TaskFrequency;
model.ExeInfo = ExeInfo;
model.OperatorID = OperatorID;
model.DeptID = DeptID;
model.TaskWeek = TaskWeek;
WebDemo.BLL.WebDemo.TaskPlanHistory bll = new WebDemo.BLL.WebDemo.TaskPlanHistory();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.TaskPlanHistory DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.TaskPlanHistory model = new WebDemo.Model.WebDemo.TaskPlanHistory();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["TaskID"] != null && row["TaskID"].ToString() != "")
{
model.TaskID = int.Parse(row["TaskID"].ToString());
}
if (row["CollectorID"] != null && row["CollectorID"].ToString() != "")
{
model.CollectorID = int.Parse(row["CollectorID"].ToString());
}
if (row["TaskName"] != null)
{
model.TaskName = row["TaskName"].ToString();
}
if (row["CommandID"] != null && row["CommandID"].ToString() != "")
{
model.CommandID = int.Parse(row["CommandID"].ToString());
}
if (row["CommandInfo"] != null)
{
model.CommandInfo = row["CommandInfo"].ToString();
}
if (row["MeterAddr"] != null)
{
model.MeterAddr = row["MeterAddr"].ToString();
}
if (row["MeterType"] != null && row["MeterType"].ToString() != "")
{
model.MeterType = int.Parse(row["MeterType"].ToString());
}
if (row["MeterItem"] != null && row["MeterItem"].ToString() != "")
{
model.MeterItem = int.Parse(row["MeterItem"].ToString());
}
if (row["FreezeDate"] != null)
{
model.FreezeDate = row["FreezeDate"].ToString();
}
if (row["TaskMonth"] != null && row["TaskMonth"].ToString() != "")
{
model.TaskMonth = int.Parse(row["TaskMonth"].ToString());
}
if (row["TaskDay"] != null && row["TaskDay"].ToString() != "")
{
model.TaskDay = int.Parse(row["TaskDay"].ToString());
}
if (row["TaskHour"] != null && row["TaskHour"].ToString() != "")
{
model.TaskHour = int.Parse(row["TaskHour"].ToString());
}
if (row["TaskMinute"] != null && row["TaskMinute"].ToString() != "")
{
model.TaskMinute = int.Parse(row["TaskMinute"].ToString());
}
if (row["ExeMark"] != null && row["ExeMark"].ToString() != "")
{
model.ExeMark = int.Parse(row["ExeMark"].ToString());
}
if (row["ExeDate"] != null && row["ExeDate"].ToString() != "")
{
model.ExeDate = DateTime.Parse(row["ExeDate"].ToString());
}
if (row["ExeError"] != null && row["ExeError"].ToString() != "")
{
model.ExeError = int.Parse(row["ExeError"].ToString());
}
if (row["TaskMark"] != null && row["TaskMark"].ToString() != "")
{
model.TaskMark = int.Parse(row["TaskMark"].ToString());
}
if (row["TaskType"] != null && row["TaskType"].ToString() != "")
{
model.TaskType = int.Parse(row["TaskType"].ToString());
}
if (row["TaskError"] != null && row["TaskError"].ToString() != "")
{
model.TaskError = int.Parse(row["TaskError"].ToString());
}
if (row["TryNum"] != null && row["TryNum"].ToString() != "")
{
model.TryNum = int.Parse(row["TryNum"].ToString());
}
if (row["HostAddr"] != null)
{
model.HostAddr = row["HostAddr"].ToString();
}
if (row["InsDate"] != null && row["InsDate"].ToString() != "")
{
model.InsDate = DateTime.Parse(row["InsDate"].ToString());
}
if (row["MeterID"] != null && row["MeterID"].ToString() != "")
{
model.MeterID = int.Parse(row["MeterID"].ToString());
}
if (row["TaskFrequency"] != null && row["TaskFrequency"].ToString() != "")
{
model.TaskFrequency = int.Parse(row["TaskFrequency"].ToString());
}
if (row["ExeInfo"] != null)
{
model.ExeInfo = row["ExeInfo"].ToString();
}
if (row["OperatorID"] != null && row["OperatorID"].ToString() != "")
{
model.OperatorID = int.Parse(row["OperatorID"].ToString());
}
if (row["DeptID"] != null)
{
model.DeptID = row["DeptID"].ToString();
}
if (row["TaskWeek"] != null && row["TaskWeek"].ToString() != "")
{
model.TaskWeek = int.Parse(row["TaskWeek"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebDemo.Model.WebDemo.TaskPlanHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TaskPlanHistory(");
strSql.Append("ID,TaskID,CollectorID,TaskName,CommandID,CommandInfo,MeterAddr,MeterType,MeterItem,FreezeDate,TaskMonth,TaskDay,TaskHour,TaskMinute,ExeMark,ExeDate,ExeError,TaskMark,TaskType,TaskError,TryNum,HostAddr,InsDate,MeterID,TaskFrequency,ExeInfo,OperatorID,DeptID,TaskWeek)");
strSql.Append(" values (");
strSql.Append("@ID,@TaskID,@CollectorID,@TaskName,@CommandID,@CommandInfo,@MeterAddr,@MeterType,@MeterItem,@FreezeDate,@TaskMonth,@TaskDay,@TaskHour,@TaskMinute,@ExeMark,@ExeDate,@ExeError,@TaskMark,@TaskType,@TaskError,@TryNum,@HostAddr,@InsDate,@MeterID,@TaskFrequency,@ExeInfo,@OperatorID,@DeptID,@TaskWeek)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@TaskID", SqlDbType.Int, 4),
new SqlParameter("@CollectorID", SqlDbType.Int, 4),
new SqlParameter("@TaskName", SqlDbType.VarChar, 100),
new SqlParameter("@CommandID", SqlDbType.Int, 4),
new SqlParameter("@CommandInfo", SqlDbType.VarChar, 500),
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 50),
new SqlParameter("@MeterType", SqlDbType.Int, 4),
new SqlParameter("@MeterItem", SqlDbType.Int, 4),
new SqlParameter("@FreezeDate", SqlDbType.VarChar, 10),
new SqlParameter("@TaskMonth", SqlDbType.Int, 4),
new SqlParameter("@TaskDay", SqlDbType.Int, 4),
new SqlParameter("@TaskHour", SqlDbType.Int, 4),
new SqlParameter("@TaskMinute", SqlDbType.Int, 4),
new SqlParameter("@ExeMark", SqlDbType.Int, 4),
new SqlParameter("@ExeDate", SqlDbType.DateTime),
new SqlParameter("@ExeError", SqlDbType.Int, 4),
new SqlParameter("@TaskMark", SqlDbType.Int, 4),
new SqlParameter("@TaskType", SqlDbType.Int, 4),
new SqlParameter("@TaskError", SqlDbType.Int, 4),
new SqlParameter("@TryNum", SqlDbType.Int, 4),
new SqlParameter("@HostAddr", SqlDbType.VarChar, 50),
new SqlParameter("@InsDate", SqlDbType.DateTime),
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@TaskFrequency", SqlDbType.Int, 4),
new SqlParameter("@ExeInfo", SqlDbType.VarChar, 200),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 60),
new SqlParameter("@TaskWeek", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TaskID;
parameters[2].Value = model.CollectorID;
parameters[3].Value = model.TaskName;
parameters[4].Value = model.CommandID;
parameters[5].Value = model.CommandInfo;
parameters[6].Value = model.MeterAddr;
parameters[7].Value = model.MeterType;
parameters[8].Value = model.MeterItem;
parameters[9].Value = model.FreezeDate;
parameters[10].Value = model.TaskMonth;
parameters[11].Value = model.TaskDay;
parameters[12].Value = model.TaskHour;
parameters[13].Value = model.TaskMinute;
parameters[14].Value = model.ExeMark;
parameters[15].Value = model.ExeDate;
parameters[16].Value = model.ExeError;
parameters[17].Value = model.TaskMark;
parameters[18].Value = model.TaskType;
parameters[19].Value = model.TaskError;
parameters[20].Value = model.TryNum;
parameters[21].Value = model.HostAddr;
parameters[22].Value = model.InsDate;
parameters[23].Value = model.MeterID;
parameters[24].Value = model.TaskFrequency;
parameters[25].Value = model.ExeInfo;
parameters[26].Value = model.OperatorID;
parameters[27].Value = model.DeptID;
parameters[28].Value = model.TaskWeek;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.TaskPlanHistory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TaskPlanHistory set ");
strSql.Append("ID=@ID,");
strSql.Append("TaskID=@TaskID,");
strSql.Append("CollectorID=@CollectorID,");
strSql.Append("TaskName=@TaskName,");
strSql.Append("CommandID=@CommandID,");
strSql.Append("CommandInfo=@CommandInfo,");
strSql.Append("MeterAddr=@MeterAddr,");
strSql.Append("MeterType=@MeterType,");
strSql.Append("MeterItem=@MeterItem,");
strSql.Append("FreezeDate=@FreezeDate,");
strSql.Append("TaskMonth=@TaskMonth,");
strSql.Append("TaskDay=@TaskDay,");
strSql.Append("TaskHour=@TaskHour,");
strSql.Append("TaskMinute=@TaskMinute,");
strSql.Append("ExeMark=@ExeMark,");
strSql.Append("ExeDate=@ExeDate,");
strSql.Append("ExeError=@ExeError,");
strSql.Append("TaskMark=@TaskMark,");
strSql.Append("TaskType=@TaskType,");
strSql.Append("TaskError=@TaskError,");
strSql.Append("TryNum=@TryNum,");
strSql.Append("HostAddr=@HostAddr,");
strSql.Append("InsDate=@InsDate,");
strSql.Append("MeterID=@MeterID,");
strSql.Append("TaskFrequency=@TaskFrequency,");
strSql.Append("ExeInfo=@ExeInfo,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("DeptID=@DeptID,");
strSql.Append("TaskWeek=@TaskWeek");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@TaskID", SqlDbType.Int, 4),
new SqlParameter("@CollectorID", SqlDbType.Int, 4),
new SqlParameter("@TaskName", SqlDbType.VarChar, 100),
new SqlParameter("@CommandID", SqlDbType.Int, 4),
new SqlParameter("@CommandInfo", SqlDbType.VarChar, 500),
new SqlParameter("@MeterAddr", SqlDbType.VarChar, 50),
new SqlParameter("@MeterType", SqlDbType.Int, 4),
new SqlParameter("@MeterItem", SqlDbType.Int, 4),
new SqlParameter("@FreezeDate", SqlDbType.VarChar, 10),
new SqlParameter("@TaskMonth", SqlDbType.Int, 4),
new SqlParameter("@TaskDay", SqlDbType.Int, 4),
new SqlParameter("@TaskHour", SqlDbType.Int, 4),
new SqlParameter("@TaskMinute", SqlDbType.Int, 4),
new SqlParameter("@ExeMark", SqlDbType.Int, 4),
new SqlParameter("@ExeDate", SqlDbType.DateTime),
new SqlParameter("@ExeError", SqlDbType.Int, 4),
new SqlParameter("@TaskMark", SqlDbType.Int, 4),
new SqlParameter("@TaskType", SqlDbType.Int, 4),
new SqlParameter("@TaskError", SqlDbType.Int, 4),
new SqlParameter("@TryNum", SqlDbType.Int, 4),
new SqlParameter("@HostAddr", SqlDbType.VarChar, 50),
new SqlParameter("@InsDate", SqlDbType.DateTime),
new SqlParameter("@MeterID", SqlDbType.Int, 4),
new SqlParameter("@TaskFrequency", SqlDbType.Int, 4),
new SqlParameter("@ExeInfo", SqlDbType.VarChar, 200),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 60),
new SqlParameter("@TaskWeek", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TaskID;
parameters[2].Value = model.CollectorID;
parameters[3].Value = model.TaskName;
parameters[4].Value = model.CommandID;
parameters[5].Value = model.CommandInfo;
parameters[6].Value = model.MeterAddr;
parameters[7].Value = model.MeterType;
parameters[8].Value = model.MeterItem;
parameters[9].Value = model.FreezeDate;
parameters[10].Value = model.TaskMonth;
parameters[11].Value = model.TaskDay;
parameters[12].Value = model.TaskHour;
parameters[13].Value = model.TaskMinute;
parameters[14].Value = model.ExeMark;
parameters[15].Value = model.ExeDate;
parameters[16].Value = model.ExeError;
parameters[17].Value = model.TaskMark;
parameters[18].Value = model.TaskType;
parameters[19].Value = model.TaskError;
parameters[20].Value = model.TryNum;
parameters[21].Value = model.HostAddr;
parameters[22].Value = model.InsDate;
parameters[23].Value = model.MeterID;
parameters[24].Value = model.TaskFrequency;
parameters[25].Value = model.ExeInfo;
parameters[26].Value = model.OperatorID;
parameters[27].Value = model.DeptID;
parameters[28].Value = model.TaskWeek;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
