private void ShowInfo(int ID)
{
WebDemo.BLL.WebDemo.TaskPlan bll = new WebDemo.BLL.WebDemo.TaskPlan();
WebDemo.Model.WebDemo.TaskPlan model = bll.GetModel(ID);
this.lblID.Text = model.ID.ToString();
this.lblTaskID.Text = model.TaskID.ToString();
this.lblCollectorID.Text = model.CollectorID.ToString();
this.lblTaskName.Text = model.TaskName;
this.lblCommandID.Text = model.CommandID.ToString();
this.lblCommandInfo.Text = model.CommandInfo;
this.lblMeterAddr.Text = model.MeterAddr;
this.lblMeterType.Text = model.MeterType.ToString();
this.lblMeterItem.Text = model.MeterItem.ToString();
this.lblFreezeDate.Text = model.FreezeDate;
this.lblTaskMonth.Text = model.TaskMonth.ToString();
this.lblTaskDay.Text = model.TaskDay.ToString();
this.lblTaskHour.Text = model.TaskHour.ToString();
this.lblTaskMinute.Text = model.TaskMinute.ToString();
this.lblExeMark.Text = model.ExeMark.ToString();
this.lblExeDate.Text = model.ExeDate.ToString();
this.lblExeError.Text = model.ExeError.ToString();
this.lblTaskMark.Text = model.TaskMark.ToString();
this.lblTaskType.Text = model.TaskType.ToString();
this.lblTaskError.Text = model.TaskError.ToString();
this.lblTryNum.Text = model.TryNum.ToString();
this.lblHostAddr.Text = model.HostAddr;
this.lblInsDate.Text = model.InsDate.ToString();
this.lblMeterID.Text = model.MeterID.ToString();
this.lblTaskFrequency.Text = model.TaskFrequency.ToString();
this.lblExeInfo.Text = model.ExeInfo;
this.lblOperatorID.Text = model.OperatorID.ToString();
this.lblDeptID.Text = model.DeptID;
this.lblTaskWeek.Text = model.TaskWeek.ToString();
this.lblPriceTypeID.Text = model.PriceTypeID.ToString();
this.lblServerId.Text = model.ServerId.ToString();
this.lblExeType.Text = model.ExeType.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.TaskPlan GetModel(int ID)
{
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,PriceTypeID,ServerId,ExeType from TaskPlan ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
WebDemo.Model.WebDemo.TaskPlan model = new WebDemo.Model.WebDemo.TaskPlan();
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 += "任务编号格式错误！\\n";
}
if (!PageValidate.IsNumber(txtCollectorID.Text))
{
strErr += "集中器编号格式错误！\\n";
}
if (this.txtTaskName.Text.Trim().Length == 0)
{
strErr += "任务名称不能为空！\\n";
}
if (!PageValidate.IsNumber(txtCommandID.Text))
{
strErr += "指令编号格式错误！\\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 += "抄表数据项格式错误！\\n";
}
if (this.txtFreezeDate.Text.Trim().Length == 0)
{
strErr += "冻结日不能为空！\\n";
}
if (!PageValidate.IsNumber(txtTaskMonth.Text))
{
strErr += "执行月份(0表示每个月)格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskDay.Text))
{
strErr += "执行日期(0表示每天)格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskHour.Text))
{
strErr += "执行时格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskMinute.Text))
{
strErr += "执行分格式错误！\\n";
}
if (!PageValidate.IsNumber(txtExeMark.Text))
{
strErr += "执行标志(1-未执行；2-已执格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtExeDate.Text))
{
strErr += "执行时间格式错误！\\n";
}
if (!PageValidate.IsNumber(txtExeError.Text))
{
strErr += "重试次数格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskMark.Text))
{
strErr += "启动任务(1-启动 2 不启动格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskType.Text))
{
strErr += "任务类型格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskError.Text))
{
strErr += "TaskError格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTryNum.Text))
{
strErr += "重试次数格式错误！\\n";
}
if (this.txtHostAddr.Text.Trim().Length == 0)
{
strErr += "采集器地址不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtInsDate.Text))
{
strErr += "InsDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMeterID.Text))
{
strErr += "MeterID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTaskFrequency.Text))
{
strErr += "任务类型格式错误！\\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 (!PageValidate.IsNumber(txtPriceTypeID.Text))
{
strErr += "PriceTypeID格式错误！\\n";
}
if (!PageValidate.IsNumber(txtServerId.Text))
{
strErr += "ServerId格式错误！\\n";
}
if (!PageValidate.IsNumber(txtExeType.Text))
{
strErr += "ExeType格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
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);
int PriceTypeID = int.Parse(this.txtPriceTypeID.Text);
int ServerId = int.Parse(this.txtServerId.Text);
int ExeType = int.Parse(this.txtExeType.Text);
WebDemo.Model.WebDemo.TaskPlan model = new WebDemo.Model.WebDemo.TaskPlan();
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;
model.PriceTypeID = PriceTypeID;
model.ServerId = ServerId;
model.ExeType = ExeType;
WebDemo.BLL.WebDemo.TaskPlan bll = new WebDemo.BLL.WebDemo.TaskPlan();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.TaskPlan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TaskPlan(");
strSql.Append("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,PriceTypeID,ServerId,ExeType)");
strSql.Append(" values (");
strSql.Append("@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,@PriceTypeID,@ServerId,@ExeType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
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, 5000),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 60),
new SqlParameter("@TaskWeek", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4),
new SqlParameter("@ServerId", SqlDbType.Int, 4),
new SqlParameter("@ExeType", SqlDbType.Int, 4)
};
parameters[0].Value = model.TaskID;
parameters[1].Value = model.CollectorID;
parameters[2].Value = model.TaskName;
parameters[3].Value = model.CommandID;
parameters[4].Value = model.CommandInfo;
parameters[5].Value = model.MeterAddr;
parameters[6].Value = model.MeterType;
parameters[7].Value = model.MeterItem;
parameters[8].Value = model.FreezeDate;
parameters[9].Value = model.TaskMonth;
parameters[10].Value = model.TaskDay;
parameters[11].Value = model.TaskHour;
parameters[12].Value = model.TaskMinute;
parameters[13].Value = model.ExeMark;
parameters[14].Value = model.ExeDate;
parameters[15].Value = model.ExeError;
parameters[16].Value = model.TaskMark;
parameters[17].Value = model.TaskType;
parameters[18].Value = model.TaskError;
parameters[19].Value = model.TryNum;
parameters[20].Value = model.HostAddr;
parameters[21].Value = model.InsDate;
parameters[22].Value = model.MeterID;
parameters[23].Value = model.TaskFrequency;
parameters[24].Value = model.ExeInfo;
parameters[25].Value = model.OperatorID;
parameters[26].Value = model.DeptID;
parameters[27].Value = model.TaskWeek;
parameters[28].Value = model.PriceTypeID;
parameters[29].Value = model.ServerId;
parameters[30].Value = model.ExeType;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.TaskPlan DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.TaskPlan model = new WebDemo.Model.WebDemo.TaskPlan();
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());
}
if (row["PriceTypeID"] != null && row["PriceTypeID"].ToString() != "")
{
model.PriceTypeID = int.Parse(row["PriceTypeID"].ToString());
}
if (row["ServerId"] != null && row["ServerId"].ToString() != "")
{
model.ServerId = int.Parse(row["ServerId"].ToString());
}
if (row["ExeType"] != null && row["ExeType"].ToString() != "")
{
model.ExeType = int.Parse(row["ExeType"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.TaskPlan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TaskPlan set ");
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("PriceTypeID=@PriceTypeID,");
strSql.Append("ServerId=@ServerId,");
strSql.Append("ExeType=@ExeType");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
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, 5000),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@DeptID", SqlDbType.VarChar, 60),
new SqlParameter("@TaskWeek", SqlDbType.Int, 4),
new SqlParameter("@PriceTypeID", SqlDbType.Int, 4),
new SqlParameter("@ServerId", SqlDbType.Int, 4),
new SqlParameter("@ExeType", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.TaskID;
parameters[1].Value = model.CollectorID;
parameters[2].Value = model.TaskName;
parameters[3].Value = model.CommandID;
parameters[4].Value = model.CommandInfo;
parameters[5].Value = model.MeterAddr;
parameters[6].Value = model.MeterType;
parameters[7].Value = model.MeterItem;
parameters[8].Value = model.FreezeDate;
parameters[9].Value = model.TaskMonth;
parameters[10].Value = model.TaskDay;
parameters[11].Value = model.TaskHour;
parameters[12].Value = model.TaskMinute;
parameters[13].Value = model.ExeMark;
parameters[14].Value = model.ExeDate;
parameters[15].Value = model.ExeError;
parameters[16].Value = model.TaskMark;
parameters[17].Value = model.TaskType;
parameters[18].Value = model.TaskError;
parameters[19].Value = model.TryNum;
parameters[20].Value = model.HostAddr;
parameters[21].Value = model.InsDate;
parameters[22].Value = model.MeterID;
parameters[23].Value = model.TaskFrequency;
parameters[24].Value = model.ExeInfo;
parameters[25].Value = model.OperatorID;
parameters[26].Value = model.DeptID;
parameters[27].Value = model.TaskWeek;
parameters[28].Value = model.PriceTypeID;
parameters[29].Value = model.ServerId;
parameters[30].Value = model.ExeType;
parameters[31].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
