/// <summary> /// 获取采购单信息业务实体 /// </summary> /// <param name="caiGouDanId">采购单编号</param> /// <returns></returns> public EyouSoft.Model.MCaiGouDanInfo GetInfo(string caiGouDanId) { EyouSoft.Model.MCaiGouDanInfo info = null; var cmd = _db.GetSqlStringCommand("SELECT A.*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=A.CaoZuoRenId) AS CaoZuoRenName,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=A.FaBuRenId) AS FaBuRenName FROM tbl_CaiGouDan AS A WHERE A.CaiGouDanId=@CaiGouDanId"); _db.AddInParameter(cmd, "CaiGouDanId", DbType.AnsiStringFixedLength, caiGouDanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.MCaiGouDanInfo(); info.CaiGouBuMen = rdr["CaiGouBuMen"].ToString(); info.CaiGouDanHao = rdr["CaiGouDanHao"].ToString(); info.CaiGouDanId = caiGouDanId; info.CaiGouDanName = rdr["CaiGouDanName"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.CgsId = rdr["CgsId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.MoBanId = rdr["MoBanId"].ToString(); info.ShouHuoDiZhi = rdr["ShouHuoDiZhi"].ToString(); info.ShouHuoRenDianHua = rdr["ShouHuoRenDianHua"].ToString(); info.ShouHuoRenName = rdr["ShouHuoRenName"].ToString(); info.Status = (EyouSoft.Model.CaiGouDanStatus)rdr.GetInt32(rdr.GetOrdinal("Status")); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.FaBuRenId = rdr["FaBuRenId"].ToString(); if (!rdr.IsDBNull(rdr.GetOrdinal("FaBuTime"))) { info.FaBuTime = rdr.GetDateTime(rdr.GetOrdinal("FaBuTime")); } info.FaBuRenName = rdr["FaBuRenName"].ToString(); info.ChanPins = null; info.CaiGouDanShuoMing = rdr["CaiGouDanShuoMing"].ToString(); if (!rdr.IsDBNull(rdr.GetOrdinal("YaoQiuDaoHuoTime"))) { info.YaoQiuDaoHuoTime = rdr.GetDateTime(rdr.GetOrdinal("YaoQiuDaoHuoTime")); } info.ShouHuoDiZhiId = rdr["ShouHuoDiZhiId"].ToString(); } } if (info != null) { info.ChanPins = GetCaiGouDanChanPins(caiGouDanId); } return(info); }
/// <summary> /// 采购单添加、修改,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <param name="dingDans">订单集合</param> /// <returns></returns> public int CaiGouDan_CU(EyouSoft.Model.MCaiGouDanInfo info, IList <EyouSoft.Model.MDingDanInfo> dingDans) { var cmd = _db.GetStoredProcCommand("proc_CaiGouDan_CU"); _db.AddInParameter(cmd, "@CaiGouDanId", DbType.AnsiStringFixedLength, info.CaiGouDanId); _db.AddInParameter(cmd, "@CgsId", DbType.AnsiStringFixedLength, info.CgsId); _db.AddInParameter(cmd, "@CaiGouDanName", DbType.String, info.CaiGouDanName); _db.AddInParameter(cmd, "@MoBanId", DbType.AnsiStringFixedLength, info.MoBanId); _db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status); _db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@ShouHuoDiZhi", DbType.String, info.ShouHuoDiZhi); _db.AddInParameter(cmd, "@ShouHuoRenName", DbType.String, info.ShouHuoRenName); _db.AddInParameter(cmd, "@ShouHuoRenDianHua", DbType.String, info.ShouHuoRenDianHua); _db.AddInParameter(cmd, "@CaiGouBuMen", DbType.String, info.CaiGouBuMen); _db.AddInParameter(cmd, "@DingDanXml", DbType.String, CreateDingDanXml(dingDans)); _db.AddInParameter(cmd, "@ChanPinXml", DbType.String, CreateDingDanChanPinXml(dingDans)); _db.AddInParameter(cmd, "@CaiGouDanShuoMing", DbType.String, info.CaiGouDanShuoMing); _db.AddInParameter(cmd, "@YaoQiuDaoHuoTime", DbType.DateTime, info.YaoQiuDaoHuoTime); _db.AddInParameter(cmd, "@ShouHuoDiZhiId", DbType.AnsiStringFixedLength, info.ShouHuoDiZhiId); _db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(cmd, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(sqlExceptionCode); } return(Convert.ToInt32(_db.GetParameterValue(cmd, "@RetCode"))); }
/// <summary> /// 获取采购单信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MCaiGouDanInfo> GetCaiGouDans(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaiGouDanChaXunInfo chaXun) { IList <EyouSoft.Model.MCaiGouDanInfo> items = new List <EyouSoft.Model.MCaiGouDanInfo>(); string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaiGouDan.CaoZuoRenId) AS CaoZuoRenName,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaiGouDan.FaBuRenId) AS FaBuRenName"; StringBuilder sql = new StringBuilder(); string tableName = "tbl_CaiGouDan"; string orderByString = " IssueTime DESC "; string heJiString = ""; #region sql sql.Append(" IsDelete='0' "); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.CaiGouDanName)) { sql.AppendFormat(" AND CaiGouDanName LIKE '%{0}%' ", chaXun.CaiGouDanName); } if (!string.IsNullOrEmpty(chaXun.CaiGouDanHao)) { sql.AppendFormat(" AND CaiGouDanHao LIKE '%{0}%' ", chaXun.CaiGouDanHao); } if (chaXun.FaBuTime1.HasValue) { sql.AppendFormat(" AND IssueTime>'{0}' ", chaXun.FaBuTime1.Value.AddMinutes(-1)); } if (chaXun.FaBuTime2.HasValue) { sql.AppendFormat(" AND IssueTime<'{0}' ", chaXun.FaBuTime2.Value.AddDays(1).AddMinutes(-1)); } if (!string.IsNullOrEmpty(chaXun.CgsId)) { sql.AppendFormat(" AND CgsId='{0}' ", chaXun.CgsId); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString)) { while (rdr.Read()) { var info = new EyouSoft.Model.MCaiGouDanInfo(); info.CaiGouBuMen = rdr["CaiGouBuMen"].ToString(); info.CaiGouDanHao = rdr["CaiGouDanHao"].ToString(); info.CaiGouDanId = rdr["CaiGouDanId"].ToString(); info.CaiGouDanName = rdr["CaiGouDanName"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.CgsId = rdr["CgsId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.MoBanId = rdr["MoBanId"].ToString(); info.ShouHuoDiZhi = rdr["ShouHuoDiZhi"].ToString(); info.ShouHuoRenDianHua = rdr["ShouHuoRenDianHua"].ToString(); info.ShouHuoRenName = rdr["ShouHuoRenName"].ToString(); info.Status = (EyouSoft.Model.CaiGouDanStatus)rdr.GetInt32(rdr.GetOrdinal("Status")); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.FaBuRenId = rdr["FaBuRenId"].ToString(); if (!rdr.IsDBNull(rdr.GetOrdinal("FaBuTime"))) { info.FaBuTime = rdr.GetDateTime(rdr.GetOrdinal("FaBuTime")); } info.FaBuRenName = rdr["FaBuRenName"].ToString(); info.ChanPins = null; info.CaiGouDanShuoMing = rdr["CaiGouDanShuoMing"].ToString(); if (!rdr.IsDBNull(rdr.GetOrdinal("YaoQiuDaoHuoTime"))) { info.YaoQiuDaoHuoTime = rdr.GetDateTime(rdr.GetOrdinal("YaoQiuDaoHuoTime")); } items.Add(info); } } return(items); }
/// <summary> /// 采购单添加,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int CaiGouDan_C(EyouSoft.Model.MCaiGouDanInfo info) { if (info == null || string.IsNullOrEmpty(info.CgsId) || string.IsNullOrEmpty(info.CaiGouDanName) || string.IsNullOrEmpty(info.CaoZuoRenId)) { return(0); } if (info.ChanPins == null || info.ChanPins.Count == 0) { return(0); } info.CaiGouDanId = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; List <EyouSoft.Model.MDingDanInfo> dingDans = new List <EyouSoft.Model.MDingDanInfo>(); foreach (var item in info.ChanPins) { if (string.IsNullOrEmpty(item.GysId) || string.IsNullOrEmpty(item.ChanPinId)) { continue; } var item1 = dingDans.Find(temp => { if (temp.GysId == item.GysId) { return(true); } else { return(false); } }); item1 = item1 ?? new EyouSoft.Model.MDingDanInfo(); if (string.IsNullOrEmpty(item1.DingDanId)) { item1.DingDanId = Guid.NewGuid().ToString(); item1.GysId = item.GysId; item1.ChanPins = new List <EyouSoft.Model.MDingDanChanPinInfo>(); item1.Status = EyouSoft.Model.DingDanStatus.计划采购; item1.JinE = 0; dingDans.Add(item1); } var item2 = new EyouSoft.Model.MDingDanChanPinInfo(); item2.MingXiId = Guid.NewGuid().ToString(); item2.ChanPinId = item.ChanPinId; item2.ShuLiang = item.ShuLiang; item1.ChanPins.Add(item2); } if (dingDans == null || dingDans.Count == 0) { return(0); } int dalRetCode = dal.CaiGouDan_CU(info, dingDans); if (dalRetCode == 1) { var logInfo = new EyouSoft.Model.MCaoZuoLogInfo(); logInfo.BiaoTi = "添加采购单"; logInfo.NeiRong = "添加采购单,采购单编号:" + info.CaiGouDanId + "。"; logInfo.GuanLianId = info.CaiGouDanId; BCaoZuoLog.Log_C(logInfo); } return(dalRetCode); }
/// <summary> /// get form info /// </summary> /// <returns></returns> EyouSoft.Model.MCaiGouDanInfo GetFormInfo() { var info = new EyouSoft.Model.MCaiGouDanInfo(); info.CaiGouBuMen = YongHuInfo.BuMenName; info.CaiGouDanHao = string.Empty; info.CaiGouDanId = EditId; info.CaiGouDanName = Utils.GetFormValue(txtCaiGouDanName.UniqueID); info.CaiGouDanShuoMing = string.Empty; info.CaoZuoRenId = YongHuInfo.YongHuId; info.CaoZuoRenName = string.Empty; info.CgsId = YongHuInfo.GongSiId; info.ChanPins = new List <EyouSoft.Model.MCaiGouDanChanPinInfo>(); info.FaBuRenId = string.Empty; info.FaBuRenName = string.Empty; info.FaBuTime = DateTime.Now; info.IssueTime = DateTime.Now; info.MoBanId = Utils.GetFormValue("txtMoBan"); info.ShouHuoDiZhi = Utils.GetFormValue(txtShouHuoDiZhi.UniqueID); info.ShouHuoRenDianHua = Utils.GetFormValue(txtShouHuoRenDianHua.UniqueID); info.ShouHuoRenName = Utils.GetFormValue(txtShouHuoRenName.UniqueID); info.Status = EyouSoft.Model.CaiGouDanStatus.计划采购; info.YaoQiuDaoHuoTime = Utils.GetDateTimeNullable(Utils.GetFormValue(txtYaoQiuDaoHuoTime.UniqueID)); var txt_chanpin_id = Utils.GetFormValues("txt_chanpin_id"); var txt_chanpin_gysid = Utils.GetFormValues("txt_chanpin_gysid"); var txt_chanpin_shuliang = Utils.GetFormValues("txt_chanpin_shuliang"); var txt_chanpin_mignxiid = Utils.GetFormValues("txt_chanpin_mignxiid"); var txt_chanpin_dingdanid = Utils.GetFormValues("txt_chanpin_dingdanid"); var txt_chanpin_xuanzhong = Utils.GetFormEditorValues("txt_chanpin_xuanzhong"); if (txt_chanpin_id == null || txt_chanpin_id.Length == 0) { Utils.RCWE_AJAX("0", "操作失败:至少需要采购一件产品"); } if (txt_chanpin_id.Length != txt_chanpin_gysid.Length || txt_chanpin_id.Length != txt_chanpin_shuliang.Length || txt_chanpin_id.Length != txt_chanpin_mignxiid.Length || txt_chanpin_id.Length != txt_chanpin_dingdanid.Length || txt_chanpin_id.Length != txt_chanpin_xuanzhong.Length) { Utils.RCWE_AJAX("0", "操作失败:表单异常"); } for (int i = 0; i < txt_chanpin_id.Length; i++) { var item = new EyouSoft.Model.MCaiGouDanChanPinInfo(); item.ChanPinId = txt_chanpin_id[i]; item.GysId = txt_chanpin_gysid[i]; item.MingXiId = txt_chanpin_mignxiid[i]; item.ShuLiang = Utils.GetDecimal(txt_chanpin_shuliang[i]); item.DingDanId = txt_chanpin_dingdanid[i]; if (string.IsNullOrEmpty(item.ChanPinId) || string.IsNullOrEmpty(item.GysId) || item.ShuLiang <= 0 || txt_chanpin_xuanzhong[i] != "1") { continue; } info.ChanPins.Add(item); } if (info.ChanPins == null || info.ChanPins.Count == 0) { Utils.RCWE_AJAX("0", "操作失败:至少需要采购一件产品"); } info.ShouHuoDiZhiId = Utils.GetFormValue("radioDiZhi"); return(info); }