/// <summary> /// 增加一条数据 /// </summary> public long Add(ControlTaskModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ControlTask("); strSql.Append("TaskID,TaskTypeName,TaskTypeCode,TaskType,ControlCode,StartArea,StartDevice,TargetArea,TargetDevice,TaskParameter,TaskStatus,CreateMode,TaskPhase,CreateTime)"); strSql.Append(" values ("); strSql.Append("@TaskID,@TaskTypeName,@TaskTypeCode,@TaskType,@ControlCode,@StartArea,@StartDevice,@TargetArea,@TargetDevice,@TaskParameter,@TaskStatus,@CreateMode,@TaskPhase,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@TaskTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@TaskTypeCode", SqlDbType.Int, 4), new SqlParameter("@TaskType", SqlDbType.NVarChar, 20), new SqlParameter("@ControlCode", SqlDbType.NVarChar, 50), new SqlParameter("@StartArea", SqlDbType.NVarChar, 50), new SqlParameter("@StartDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TargetArea", SqlDbType.NVarChar, 50), new SqlParameter("@TargetDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TaskParameter", SqlDbType.NVarChar, 50), new SqlParameter("@TaskStatus", SqlDbType.NVarChar, 50), new SqlParameter("@CreateMode", SqlDbType.NVarChar, 50), new SqlParameter("@TaskPhase", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.TaskTypeName; parameters[2].Value = model.TaskTypeCode; parameters[3].Value = model.TaskType; parameters[4].Value = model.ControlCode; parameters[5].Value = model.StartArea; parameters[6].Value = model.StartDevice; parameters[7].Value = model.TargetArea; parameters[8].Value = model.TargetDevice; parameters[9].Value = model.TaskParameter; parameters[10].Value = model.TaskStatus; parameters[11].Value = model.CreateMode; parameters[12].Value = model.TaskPhase; parameters[13].Value = model.CreateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "ControlTask"; * parameters[1].Value = "ControlTaskID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 获取插入控制任务hash /// </summary> /// <param name="model"></param> /// <returns></returns> public Hashtable GetAddModelHash(ControlTaskModel model) { Hashtable hs = new Hashtable(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ControlTask("); strSql.Append("TaskID,TaskTypeName,TaskTypeCode,TaskType,ControlCode,StartArea,StartDevice,TargetArea,TargetDevice,TaskParameter,TaskStatus,CreateMode,CreateTime,TaskPhase)"); strSql.Append(" values ("); strSql.Append("@TaskID,@TaskTypeName,@TaskTypeCode,@TaskType,@ControlCode,@StartArea,@StartDevice,@TargetArea,@TargetDevice,@TaskParameter,@TaskStatus,@CreateMode,@CreateTime,@TaskPhase)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@TaskTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@TaskTypeCode", SqlDbType.Int, 4), new SqlParameter("@TaskType", SqlDbType.NVarChar, 20), new SqlParameter("@ControlCode", SqlDbType.NVarChar, 50), new SqlParameter("@StartArea", SqlDbType.NVarChar, 50), new SqlParameter("@StartDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TargetArea", SqlDbType.NVarChar, 50), new SqlParameter("@TargetDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TaskParameter", SqlDbType.NVarChar, 50), new SqlParameter("@TaskStatus", SqlDbType.NVarChar, 50), new SqlParameter("@CreateMode", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@TaskPhase", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.TaskTypeName; parameters[2].Value = model.TaskTypeCode; parameters[3].Value = model.TaskType; parameters[4].Value = model.ControlCode; parameters[5].Value = model.StartArea; parameters[6].Value = model.StartDevice; parameters[7].Value = model.TargetArea; parameters[8].Value = model.TargetDevice; parameters[9].Value = model.TaskParameter; parameters[10].Value = model.TaskStatus; parameters[11].Value = model.CreateMode; parameters[12].Value = model.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"); parameters[13].Value = model.TaskPhase; hs.Add(strSql.ToString(), parameters); return(hs); }
public IList <ControlTaskModel> GetConditionedModel(string strWhere) { IList <ControlTaskModel> modelList = new List <ControlTaskModel>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM ControlTask "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ControlTaskModel m = DataRowToModel(dr); modelList.Add(m); } } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public ControlTaskModel GetModel(long ControlTaskID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ControlTaskID,TaskID,TaskTypeName,TaskTypeCode,TaskType,ControlCode,StartArea,StartDevice,TargetArea,TargetDevice,TaskParameter,TaskStatus,CreateMode,TaskPhase,CreateTime from ControlTask "); strSql.Append(" where ControlTaskID=@ControlTaskID"); SqlParameter[] parameters = { new SqlParameter("@ControlTaskID", SqlDbType.BigInt) }; parameters[0].Value = ControlTaskID; ControlTaskModel model = new ControlTaskModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ControlTaskModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(ControlTaskModel model) { return(dal.Add(model)); }
/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod /// <summary> /// 获取插入控制任务hash /// </summary> /// <param name="model"></param> /// <returns></returns> public Hashtable GetAddControlTaskHash(ControlTaskModel model) { return(dal.GetAddModelHash(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public ControlTaskModel DataRowToModel(DataRow row) { ControlTaskModel model = new ControlTaskModel(); if (row != null) { if (row["ControlTaskID"] != null && row["ControlTaskID"].ToString() != "") { model.ControlTaskID = long.Parse(row["ControlTaskID"].ToString()); } if (row["TaskID"] != null && row["TaskID"].ToString() != "") { model.TaskID = long.Parse(row["TaskID"].ToString()); } if (row["TaskTypeName"] != null) { model.TaskTypeName = row["TaskTypeName"].ToString(); } if (row["TaskTypeCode"] != null && row["TaskTypeCode"].ToString() != "") { model.TaskTypeCode = int.Parse(row["TaskTypeCode"].ToString()); } if (row["TaskType"] != null) { model.TaskType = row["TaskType"].ToString(); } if (row["ControlCode"] != null) { model.ControlCode = row["ControlCode"].ToString(); } if (row["StartArea"] != null) { model.StartArea = row["StartArea"].ToString(); } if (row["StartDevice"] != null) { model.StartDevice = row["StartDevice"].ToString(); } if (row["TargetArea"] != null) { model.TargetArea = row["TargetArea"].ToString(); } if (row["TargetDevice"] != null) { model.TargetDevice = row["TargetDevice"].ToString(); } if (row["TaskParameter"] != null) { model.TaskParameter = row["TaskParameter"].ToString(); } if (row["TaskStatus"] != null) { model.TaskStatus = row["TaskStatus"].ToString(); } if (row["CreateMode"] != null) { model.CreateMode = row["CreateMode"].ToString(); } if (row["TaskPhase"] != null) { model.TaskPhase = row["TaskPhase"].ToString(); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ControlTaskModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ControlTask set "); strSql.Append("TaskID=@TaskID,"); strSql.Append("TaskTypeName=@TaskTypeName,"); strSql.Append("TaskTypeCode=@TaskTypeCode,"); strSql.Append("TaskType=@TaskType,"); strSql.Append("ControlCode=@ControlCode,"); strSql.Append("StartArea=@StartArea,"); strSql.Append("StartDevice=@StartDevice,"); strSql.Append("TargetArea=@TargetArea,"); strSql.Append("TargetDevice=@TargetDevice,"); strSql.Append("TaskParameter=@TaskParameter,"); strSql.Append("TaskStatus=@TaskStatus,"); strSql.Append("CreateMode=@CreateMode,"); strSql.Append("TaskPhase=@TaskPhase,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where ControlTaskID=@ControlTaskID"); SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@TaskTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@TaskTypeCode", SqlDbType.Int, 4), new SqlParameter("@TaskType", SqlDbType.NVarChar, 20), new SqlParameter("@ControlCode", SqlDbType.NVarChar, 50), new SqlParameter("@StartArea", SqlDbType.NVarChar, 50), new SqlParameter("@StartDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TargetArea", SqlDbType.NVarChar, 50), new SqlParameter("@TargetDevice", SqlDbType.NVarChar, 50), new SqlParameter("@TaskParameter", SqlDbType.NVarChar, 50), new SqlParameter("@TaskStatus", SqlDbType.NVarChar, 50), new SqlParameter("@CreateMode", SqlDbType.NVarChar, 50), new SqlParameter("@TaskPhase", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ControlTaskID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.TaskTypeName; parameters[2].Value = model.TaskTypeCode; parameters[3].Value = model.TaskType; parameters[4].Value = model.ControlCode; parameters[5].Value = model.StartArea; parameters[6].Value = model.StartDevice; parameters[7].Value = model.TargetArea; parameters[8].Value = model.TargetDevice; parameters[9].Value = model.TaskParameter; parameters[10].Value = model.TaskStatus; parameters[11].Value = model.CreateMode; parameters[12].Value = model.TaskPhase; parameters[13].Value = model.CreateTime; parameters[14].Value = model.ControlTaskID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }