public bool GetOverViewDetailByPage(ref List <OverViewDetailInfo> modelList, OverViewDetailInfo model, ref DividPage page, UserInfo user, ref string strError) { if (page == null) { page = new DividPage(); } List <OverViewDetailInfo> lstModel = new List <OverViewDetailInfo>(); try { using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_OverViewDetail", GetFilterSql(model, user))) { while (dr.Read()) { lstModel.Add(GetModelFromDataReader(dr)); } } modelList = lstModel; return(true); } catch (Exception ex) { strError = ex.Message; return(false); } finally { } }
private OverViewDetailInfo GetModelFromDataReader(SqlDataReader dr) { OverViewDetailInfo model = new OverViewDetailInfo(); model.ID = dr["ID"].ToInt32(); model.ToAreaNo = dr["ToAreaNo"].ToDBString(); model.MaterialNo = dr["MaterialNo"].ToDBString(); model.MaterialDesc = dr["MaterialDesc"].ToDBString(); model.TaskQty = dr["TaskQty"].ToDecimal(); model.QualityQty = dr["QualityQty"].ToDecimal(); model.RemainQty = dr["RemainQty"].ToDecimal(); model.ShelveQty = dr["ShelveQty"].ToDecimal(); model.Status = dr["Status"].ToInt32(); model.IsQualityComp = dr["IsQualityComp"].ToInt32(); model.KeeperUserNo = dr["KeeperUserNo"].ToDBString(); model.OperatorUserNo = dr["OperatorUserNo"].ToDBString(); model.CompleteDateTime = dr["CompleteDateTime"].ToDateTimeNull(); model.Task_ID = dr["Task_ID"].ToInt32(); model.TMaterialNo = dr["TMaterialNo"].ToDBString(); model.TMaterialDesc = dr["TMaterialDesc"].ToDBString(); model.OperatorDateTime = dr["OperatorDateTime"].ToDateTimeNull(); model.ReviewQty = dr["ReviewQty"].ToDecimal(); model.PackCount = dr["PackCount"].ToInt32(); model.ShelvePackCount = dr["ShelvePackCount"].ToInt32(); model.VoucherNo = dr["VoucherNo"].ToDBString(); model.RowNo = dr["RowNo"].ToDBString(); model.CreateDate = dr["CreateDate"].ToDateTimeNull(); model.TrackNo = dr["TrackNo"].ToDBString(); model.Unit = dr["Unit"].ToDBString(); model.UnQualityQty = dr["UnQualityQty"].ToDecimal(); model.PostQty = dr["PostQty"].ToDecimal(); model.StrStatus = dr["StrStatus"].ToDBString(); model.StrIsQualityComp = dr["StrIsQualityComp"].ToDBString(); model.KeeperUserName = dr["KeeperUserName"].ToDBString(); model.OperatorUserName = dr["OperatorUserName"].ToDBString(); return(model); }
private string GetFilterSql(OverViewDetailInfo model, UserInfo user) { try { string strSql = " Where ISNULL(MaterialNo,TMaterialNo) is not null "; bool hadWhere = true; if (model.Task_ID >= 1) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " Task_ID = " + model.Task_ID + " "; hadWhere = true; } if (model.Status >= 1) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " Status = " + model.Status + " "; hadWhere = true; } if (model.IsQualityComp >= 1) { strSql = Common_Func.AddWhereAnd(strSql, hadWhere); strSql += " IsQualityComp = " + model.IsQualityComp + " "; hadWhere = true; } return(strSql); } catch { return(string.Empty); } }