public static StorageDoc GetStorageDetail(string docid, string agentid, string clientid)
{
DataSet ds = StockDAL.GetStorageDetail(docid, clientid);
StorageDoc model = new StorageDoc();
if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0)
{
model.FillData(ds.Tables["Doc"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, agentid);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.DocTypeStr = CommonBusiness.GetEnumDesc<EnumDocType>((EnumDocType)model.DocType);
model.WareHouse = SystemBusiness.BaseBusiness.GetWareByID(model.WareID, model.ClientID);
model.Details = new List<StorageDetail>();
foreach (DataRow item in ds.Tables["Details"].Rows)
{
StorageDetail details = new StorageDetail();
details.FillData(item);
if (!string.IsNullOrEmpty(details.UnitID))
{
details.UnitName = ProductsBusiness.BaseBusiness.GetUnitByID(details.UnitID, clientid).UnitName;
}
model.Details.Add(details);
}
}
return model;
}
public static List<StorageDoc> GetStorageDocList(string userid, EnumDocType type, EnumDocStatus status, string keywords, string begintime, string endtime, string wareid, string providerid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string agentid, string clientid)
{
DataSet ds = StockDAL.GetStorageDocList(userid, (int)type, (int)status, keywords, begintime, endtime, wareid, providerid, pageSize, pageIndex, ref totalCount, ref pageCount, clientid);
List<StorageDoc> list = new List<StorageDoc>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
StorageDoc model = new StorageDoc();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, agentid);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.WareHouse = SystemBusiness.BaseBusiness.GetWareByID(model.WareID, model.ClientID);
list.Add(model);
}
return list;
}
/// <summary>
/// 创建单据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static string CreateStorageDoc(StorageDoc model, string userid, string operateip, string clientid)
{
string docid = Guid.NewGuid().ToString();
SqlConnection conn = new SqlConnection(OrdersDAL.ConnectionString);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
bool bl = OrdersDAL.AddStorageDoc(docid, model.DocType, model.TotalMoney, model.CityCode, model.Address, model.Remark, userid, operateip, clientid, tran);
if (bl)
{
//单据明细
foreach (var detail in model.Details)
{
if (!OrdersDAL.AddStorageDocDetail(docid, detail.AutoID, detail.ProductDetailID, detail.Quantity, detail.Price, detail.TotalMoney, detail.BatchCode, clientid, tran))
{
tran.Rollback();
conn.Dispose();
return "";
}
}
tran.Commit();
conn.Dispose();
return docid;
}
else
{
tran.Rollback();
conn.Dispose();
return "";
}
}
catch (Exception ex)
{
tran.Rollback();
conn.Dispose();
return "";
}
}
public static StorageDoc GetStorageDetail(string docid, string clientid)
{
DataSet ds = StockDAL.GetStorageDetail(docid, clientid);
StorageDoc model = new StorageDoc();
if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0)
{
model.FillData(ds.Tables["Doc"].Rows[0]);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
model.WareHouse = SystemBusiness.BaseBusiness.GetWareByID(model.WareID, model.ClientID);
model.Details = new List<StorageDetail>();
foreach (DataRow item in ds.Tables["Details"].Rows)
{
StorageDetail details = new StorageDetail();
details.FillData(item);
model.Details.Add(details);
}
}
return model;
}
/// <summary>
/// 获取单据列表
/// </summary>
/// <param name="userid">创建人（拥有者）</param>
/// <param name="type">类型</param>
/// <param name="status">状态</param>
/// <param name="keywords">关键词</param>
/// <param name="pageSize">页Size</param>
/// <param name="pageIndex">页码</param>
/// <param name="totalCount">总数</param>
/// <param name="pageCount"><总页/param>
/// <param name="clientID">客户端ID</param>
/// <returns></returns>
public static List<StorageDoc> GetStorageDocList(string userid, EnumDocType type, EnumDocStatus status, string keywords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
{
DataSet ds = OrdersDAL.GetStorageDocList(userid, (int)type, (int)status, keywords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);
List<StorageDoc> list = new List<StorageDoc>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
StorageDoc model = new StorageDoc();
model.FillData(dr);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientID);
model.StatusStr = GetDocStatusStr(model.DocType, model.Status);
list.Add(model);
}
return list;
}
