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); } }