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