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