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