/// <summary> /// 增加一条数据 /// </summary> public long Add(PalletHistoryRecordModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PalletHistoryRecord("); strSql.Append("palletID,hisEventTime,processStatus,hisEventDetail,currentUser)"); strSql.Append(" values ("); strSql.Append("@palletID,@hisEventTime,@processStatus,@hisEventDetail,@currentUser)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@palletID", SqlDbType.NVarChar, 50), new SqlParameter("@hisEventTime", SqlDbType.DateTime), new SqlParameter("@processStatus", SqlDbType.NVarChar, 50), new SqlParameter("@hisEventDetail", SqlDbType.NVarChar, 100), new SqlParameter("@currentUser", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.palletID; parameters[1].Value = model.hisEventTime; parameters[2].Value = model.processStatus; parameters[3].Value = model.hisEventDetail; parameters[4].Value = model.currentUser; 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 = "PalletHistoryRecord"; * parameters[1].Value = "serialNo"; * 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 Method #region 扩展方法 /// <summary> /// 获得数据列表 /// </summary> public List <PalletHistoryRecordModel> GetList(string strWhere, bool timeAsc) { StringBuilder strSql = new StringBuilder(); strSql.Append("select serialNo,palletID,hisEventTime,processStatus,hisEventDetail,currentUser "); strSql.Append(" FROM PalletHistoryRecord "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } if (timeAsc) { strSql.Append("order by hisEventTime asc"); } else { strSql.Append("order by hisEventTime desc"); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); List <PalletHistoryRecordModel> eventList = new List <PalletHistoryRecordModel>(); if (ds.Tables[0].Rows.Count <= 0) { return(null); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { PalletHistoryRecordModel model = new PalletHistoryRecordModel(); if (ds.Tables[0].Rows[i]["serialNo"] != null && ds.Tables[0].Rows[i]["serialNo"].ToString() != "") { model.serialNo = long.Parse(ds.Tables[0].Rows[i]["serialNo"].ToString()); } if (ds.Tables[0].Rows[i]["palletID"] != null && ds.Tables[0].Rows[i]["palletID"].ToString() != "") { model.palletID = ds.Tables[0].Rows[i]["palletID"].ToString(); } if (ds.Tables[0].Rows[i]["hisEventTime"] != null && ds.Tables[0].Rows[i]["hisEventTime"].ToString() != "") { model.hisEventTime = DateTime.Parse(ds.Tables[0].Rows[i]["hisEventTime"].ToString()); } if (ds.Tables[0].Rows[i]["processStatus"] != null && ds.Tables[0].Rows[i]["processStatus"].ToString() != "") { model.processStatus = ds.Tables[0].Rows[i]["processStatus"].ToString(); } if (ds.Tables[0].Rows[i]["hisEventDetail"] != null && ds.Tables[0].Rows[i]["hisEventDetail"].ToString() != "") { model.hisEventDetail = ds.Tables[0].Rows[i]["hisEventDetail"].ToString(); } if (ds.Tables[0].Rows[i]["currentUser"] != null && ds.Tables[0].Rows[i]["currentUser"].ToString() != "") { model.currentUser = ds.Tables[0].Rows[i]["currentUser"].ToString(); } eventList.Add(model); } return(eventList); }
/// <summary> /// 得到一个对象实体 /// </summary> public PalletHistoryRecordModel GetModel(long serialNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 serialNo,palletID,hisEventTime,processStatus,hisEventDetail,currentUser from PalletHistoryRecord "); strSql.Append(" where serialNo=@serialNo"); SqlParameter[] parameters = { new SqlParameter("@serialNo", SqlDbType.BigInt) }; parameters[0].Value = serialNo; PalletHistoryRecordModel model = new PalletHistoryRecordModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["serialNo"] != null && ds.Tables[0].Rows[0]["serialNo"].ToString() != "") { model.serialNo = long.Parse(ds.Tables[0].Rows[0]["serialNo"].ToString()); } if (ds.Tables[0].Rows[0]["palletID"] != null && ds.Tables[0].Rows[0]["palletID"].ToString() != "") { model.palletID = ds.Tables[0].Rows[0]["palletID"].ToString(); } if (ds.Tables[0].Rows[0]["hisEventTime"] != null && ds.Tables[0].Rows[0]["hisEventTime"].ToString() != "") { model.hisEventTime = DateTime.Parse(ds.Tables[0].Rows[0]["hisEventTime"].ToString()); } if (ds.Tables[0].Rows[0]["processStatus"] != null && ds.Tables[0].Rows[0]["processStatus"].ToString() != "") { model.processStatus = ds.Tables[0].Rows[0]["processStatus"].ToString(); } if (ds.Tables[0].Rows[0]["hisEventDetail"] != null && ds.Tables[0].Rows[0]["hisEventDetail"].ToString() != "") { model.hisEventDetail = ds.Tables[0].Rows[0]["hisEventDetail"].ToString(); } if (ds.Tables[0].Rows[0]["currentUser"] != null && ds.Tables[0].Rows[0]["currentUser"].ToString() != "") { model.currentUser = ds.Tables[0].Rows[0]["currentUser"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion Method #region 扩展方法 /// <summary> /// 增加历史事件 /// </summary> /// <param name="palletID"></param> /// <param name="processStatus"></param> /// <param name="eventDetail"></param> /// <param name="userName"></param> /// <returns></returns> public bool AddHistoryEvent(string palletID, string processStatus, string eventDetail, string userName) { DeleteHistoryLog(60);//两个月 PalletHistoryRecordModel hisModel = new PalletHistoryRecordModel(); hisModel.currentUser = userName; hisModel.hisEventTime = System.DateTime.Now; hisModel.palletID = palletID; hisModel.hisEventDetail = eventDetail; hisModel.processStatus = processStatus; if (dal.Add(hisModel) <= 0) { return(false); } return(true); }
/// <summary> /// 获得数据列表 /// </summary> public List <PalletHistoryRecordModel> DataTableToList(DataTable dt) { List <PalletHistoryRecordModel> modelList = new List <PalletHistoryRecordModel>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { PalletHistoryRecordModel model; for (int n = 0; n < rowsCount; n++) { model = new PalletHistoryRecordModel(); if (dt.Rows[n]["serialNo"] != null && dt.Rows[n]["serialNo"].ToString() != "") { model.serialNo = long.Parse(dt.Rows[n]["serialNo"].ToString()); } if (dt.Rows[n]["palletID"] != null && dt.Rows[n]["palletID"].ToString() != "") { model.palletID = dt.Rows[n]["palletID"].ToString(); } if (dt.Rows[n]["hisEventTime"] != null && dt.Rows[n]["hisEventTime"].ToString() != "") { model.hisEventTime = DateTime.Parse(dt.Rows[n]["hisEventTime"].ToString()); } if (dt.Rows[n]["processStatus"] != null && dt.Rows[n]["processStatus"].ToString() != "") { model.processStatus = dt.Rows[n]["processStatus"].ToString(); } if (dt.Rows[n]["hisEventDetail"] != null && dt.Rows[n]["hisEventDetail"].ToString() != "") { model.hisEventDetail = dt.Rows[n]["hisEventDetail"].ToString(); } if (dt.Rows[n]["currentUser"] != null && dt.Rows[n]["currentUser"].ToString() != "") { model.currentUser = dt.Rows[n]["currentUser"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(PalletHistoryRecordModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PalletHistoryRecord set "); strSql.Append("palletID=@palletID,"); strSql.Append("hisEventTime=@hisEventTime,"); strSql.Append("processStatus=@processStatus,"); strSql.Append("hisEventDetail=@hisEventDetail,"); strSql.Append("currentUser=@currentUser"); strSql.Append(" where serialNo=@serialNo"); SqlParameter[] parameters = { new SqlParameter("@palletID", SqlDbType.NVarChar, 50), new SqlParameter("@hisEventTime", SqlDbType.DateTime), new SqlParameter("@processStatus", SqlDbType.NVarChar, 50), new SqlParameter("@hisEventDetail", SqlDbType.NVarChar, 100), new SqlParameter("@currentUser", SqlDbType.NVarChar, 50), new SqlParameter("@serialNo", SqlDbType.BigInt, 8) }; parameters[0].Value = model.palletID; parameters[1].Value = model.hisEventTime; parameters[2].Value = model.processStatus; parameters[3].Value = model.hisEventDetail; parameters[4].Value = model.currentUser; parameters[5].Value = model.serialNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(PalletHistoryRecordModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(PalletHistoryRecordModel model) { return(dal.Add(model)); }