/// <summary>
/// 批量修改上传标志
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="if_flag">上传标志</param>
/// <param name="CCInfoList">单据集合</param>
/// <param name="IsTrans">是否提交</param>
/// <returns></returns>
public bool SetCCIfFlag(LoggingSessionInfo loggingSessionInfo, string if_flag, IList <CCInfo> CCInfoList, bool IsTrans)
{
if (IsTrans)
{
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).BeginTransaction();
}
try
{
bool bReturn = false;
CCInfo inoutInfo = new CCInfo();
inoutInfo.if_flag = if_flag;
inoutInfo.CCInfoList = CCInfoList;
inoutInfo.modify_time = GetCurrentDateTime();
inoutInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("CC.UpdateIfflag", inoutInfo);
if (IsTrans)
{
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).CommitTransaction();
}
return(bReturn);
}
catch (Exception ex)
{
if (IsTrans)
{
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).RollBackTransaction();
}
throw (ex);
}
}
//保存CCBill的数据
private CCInfo currentccbillData()
{
CCInfo ccbill = new CCInfo();
ccbill.order_no = this.tbOrderNo.Text;
ccbill.unit_id = this.selUnit.SelectedValue;
ccbill.warehouse_id = this.selWarehouse.SelectedValue ?? "";
ccbill.complete_date = this.selCompleteDate.Value;
ccbill.order_date = this.selOrderDate.Value;
ccbill.remark = this.tbRemark.Text;
ccbill.status = "1";
//IList<CCDetailInfo> ccdetailList;//获取从添加商品页面回来的数据信息。
if (ViewState["action"].ToString() == "Create")
{
ccbill.operate = "Create";
ccbill.order_id = "";
ccbill.status = "1";
ccbill.create_time = new BaseService().GetCurrentDateTime();
ccbill.create_user_id = loggingSessionInfo.CurrentUser.User_Id;
}
else
{
ccbill.operate = "Modify";
//ccbill.status = "";
ccbill.order_id = this.Request.QueryString["order_id"];
ccbill.modify_time = new BaseService().GetCurrentDateTime();
ccbill.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
}
IList <CCDetailInfo> ccDetalList = saveItemDetailList();
ccbill.CCDetailInfoList = ccDetalList;
return(ccbill);
}
private void saveccbillData()
{
CCInfo ccInfo = currentccbillData();
try
{
bool IsTrans = true;
string strError = string.Empty;
bool saved = new CCService().SetCCInfo(loggingSessionInfo, ccInfo, IsTrans, out strError);
if (saved)
{
this.Redirect("保存成功", InfoType.Info, this.Request.QueryString["from"] ?? "cc_bill_query.aspx");
}
else
{
this.InfoBox.ShowPopError(strError);
}
this.CCDetailInfoList = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(ccInfo.CCDetailInfoList);
}
catch (Exception ex)
{
this.InfoBox.ShowPopError("访问数据库出错!");
this.CCDetailInfoList = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(ccInfo.CCDetailInfoList);
}
}
/// <summary>
/// 盘点单提交到表单中
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfo"></param>
/// <returns></returns>
private bool SetInoutOrderInsertBill(LoggingSessionInfo loggingSessionInfo, CCInfo ccInfo)
{
try
{
cPos.Model.BillModel bill = new BillModel();
cPos.Service.cBillService bs = new cBillService();
bill.Id = ccInfo.order_id;
string order_type_id = bs.GetBillKindByCode(loggingSessionInfo, ccInfo.BillKindCode).Id.ToString(); //loggingSession, OrderType
bill.Code = bs.GetBillNextCode(loggingSessionInfo, ccInfo.BillKindCode); //BillKindCode
bill.KindId = order_type_id;
bill.UnitId = loggingSessionInfo.CurrentUserRole.UnitId;
bill.AddUserId = loggingSessionInfo.CurrentUser.User_Id;
BillOperateStateService state = bs.InsertBill(loggingSessionInfo, bill);
if (state == BillOperateStateService.CreateSuccessful)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 盘点单提交到表单中
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfo"></param>
/// <returns></returns>
private bool SetInoutOrderInsertBill(CCInfo ccInfo)
{
try
{
//BillModel bill = new BillModel();
//BillService bs = new BillService(loggingSessionInfo);
//bill.Id = ccInfo.order_id;
//string order_type_id = bs.GetBillKindByCode(loggingSessionInfo, ccInfo.BillKindCode).Id.ToString(); //loggingSession, OrderType
//bill.Code = bs.GetBillNextCode(loggingSessionInfo, ccInfo.BillKindCode); //BillKindCode
//bill.KindId = order_type_id;
//bill.UnitId = loggingSessionInfo.CurrentUserRole.UnitId;
//bill.AddUserId = loggingSessionInfo.CurrentUser.User_Id;
//BillOperateStateService state = bs.InsertBill(loggingSessionInfo, bill);
//if (state == BillOperateStateService.CreateSuccessful)
//{
// return true;
//}
//else
//{
// return false;
//}
return(false);
}
catch (Exception ex)
{
throw (ex);
}
}
protected virtual void AddCCInfo(string elementName, CCInfo creditCard)
{
if (!String.IsNullOrEmpty(creditCard.CreditCardNumber))
{
AddUpdateMessage(elementName, "CreditCardNumber", creditCard.CreditCardNumber);
}
if (creditCard.ExpirationMonth != 0)
{
AddUpdateMessage(elementName, "ExpirationMonth", creditCard.ExpirationMonth);
}
if (creditCard.ExpirationYear != 0)
{
AddUpdateMessage(elementName, "ExpirationYear", creditCard.ExpirationYear);
}
if (!String.IsNullOrEmpty(creditCard.NameOnCard))
{
AddUpdateMessage(elementName, "NameOnCard", creditCard.NameOnCard);
}
if (!String.IsNullOrEmpty(creditCard.CreditCardAddress))
{
AddUpdateMessage(elementName, "CreditCardAddress", creditCard.CreditCardAddress);
}
if (!String.IsNullOrEmpty(creditCard.CreditCardPostalCode))
{
AddUpdateMessage(elementName, "CreditCardPostalCode", creditCard.CreditCardPostalCode);
}
}
public static void Main(string[] args)
{
CCInfo ccInfo = new CCInfo();
UCInfo ucInfo = new UCInfo();
IBaseInfo <BaseDecision> x = ccInfo;
x = ucInfo;
}
/// <summary>
/// 批量保存盘点单
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfoList"></param>
/// <param name="strError"></param>
/// <returns></returns>
public bool SetCCInfoList(LoggingSessionInfo loggingSessionInfo, IList <CCInfo> ccInfoList, out string strError)
{
foreach (CCInfo ccInfo1 in ccInfoList)
{
}
CCInfo ccInfo = new CCInfo();
ccInfo.CCInfoList = ccInfoList;
bool bReturn = SetCCInfo(ccInfo, false, out strError);
return(bReturn);
}
/// <summary>
/// 盘点单查询
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="order_no">单据号码</param>
/// <param name="status">状态标识</param>
/// <param name="unit_id">单位标识</param>
/// <param name="warehouse_id">仓库标识</param>
/// <param name="order_date_begin">单据日期开始【yyyy-MM-dd】</param>
/// <param name="order_date_end">单据日期结束【yyyy-MM-dd】</param>
/// <param name="complete_date_begin">完成日期开始【yyyy-MM-dd】</param>
/// <param name="complete_date_end">完成日期结束【yyyy-MM-dd】</param>
/// <param name="data_from_id">数据来源标识</param>
/// <param name="maxRowCount">每页最大数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public CCInfo SearchCCInfo(LoggingSessionInfo loggingSessionInfo
, string order_no
, string status
, string unit_id
, string warehouse_id
, string order_date_begin
, string order_date_end
, string complete_date_begin
, string complete_date_end
, string data_from_id
, int maxRowCount
, int startRowIndex
)
{
try
{
OrderSearchInfo orderSearchInfo = new OrderSearchInfo();
orderSearchInfo.order_no = order_no;
orderSearchInfo.status = status;
orderSearchInfo.unit_id = unit_id;
orderSearchInfo.warehouse_id = warehouse_id;
orderSearchInfo.order_date_begin = order_date_begin;
orderSearchInfo.order_date_end = order_date_end;
orderSearchInfo.complete_date_begin = complete_date_begin;
orderSearchInfo.complete_date_end = complete_date_end;
orderSearchInfo.data_from_id = data_from_id;
orderSearchInfo.StartRow = startRowIndex;
orderSearchInfo.EndRow = startRowIndex + maxRowCount;
orderSearchInfo.customer_id = loggingSessionInfo.CurrentLoggingManager.Customer_Id;
orderSearchInfo.order_type_id = "51BE351BFA5E49A490103669EA21BC3C";
CCInfo ccInfo = new CCInfo();
int iCount = ccService.SearchCCCount(orderSearchInfo);
IList <CCInfo> ccInfoList = new List <CCInfo>();
DataSet ds = ccService.SearchCCInfo(orderSearchInfo);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
ccInfoList = DataTableToObject.ConvertToList <CCInfo>(ds.Tables[0]);
}
ccInfo.ICount = iCount;
ccInfo.CCInfoList = ccInfoList;
return(ccInfo);
}
catch (Exception ex) {
throw (ex);
}
}
/// <summary>
/// 修改出入库单据状态
/// </summary>
/// <param name="ccInfo"></param>
/// <returns></returns>
public bool SetCCStatusUpdate(CCInfo ccInfo)
{
string sql = "update T_CC set [status] = '" + ccInfo.status + "' ,status_desc = '" + ccInfo.status_desc + "'"
+ " ,Modify_Time = '" + ccInfo.modify_time + "' ,Modify_User_Id = '" + ccInfo.modify_user_id + "' ";
PublicService pService = new PublicService();
sql = pService.GetIsNotNullUpdateSql(sql, "approve_user_id", ccInfo.approve_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_time", ccInfo.approve_time);
sql = sql + " ,if_flag = '0' where order_id = '" + ccInfo.order_id + "'";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 盘点单查询
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="order_no">单据号码</param>
/// <param name="status">状态标识</param>
/// <param name="unit_id">单位标识</param>
/// <param name="warehouse_id">仓库标识</param>
/// <param name="order_date_begin">单据日期开始【yyyy-MM-dd】</param>
/// <param name="order_date_end">单据日期结束【yyyy-MM-dd】</param>
/// <param name="complete_date_begin">完成日期开始【yyyy-MM-dd】</param>
/// <param name="complete_date_end">完成日期结束【yyyy-MM-dd】</param>
/// <param name="data_from_id">数据来源标识</param>
/// <param name="maxRowCount">每页最大数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public CCInfo SearchCCInfo(LoggingSessionInfo loggingSessionInfo
, string order_no
, string status
, string unit_id
, string warehouse_id
, string order_date_begin
, string order_date_end
, string complete_date_begin
, string complete_date_end
, string data_from_id
, int maxRowCount
, int startRowIndex
)
{
try
{
OrderSearchInfo orderSearchInfo = new OrderSearchInfo();
orderSearchInfo.order_no = order_no;
orderSearchInfo.status = status;
orderSearchInfo.unit_id = unit_id;
orderSearchInfo.warehouse_id = warehouse_id;
orderSearchInfo.order_date_begin = order_date_begin;
orderSearchInfo.order_date_end = order_date_end;
orderSearchInfo.complete_date_begin = complete_date_begin;
orderSearchInfo.complete_date_end = complete_date_end;
orderSearchInfo.data_from_id = data_from_id;
orderSearchInfo.StartRow = startRowIndex;
orderSearchInfo.EndRow = startRowIndex + maxRowCount;
orderSearchInfo.customer_id = loggingSessionInfo.CurrentLoggingManager.Customer_Id;
orderSearchInfo.order_type_id = "51BE351BFA5E49A490103669EA21BC3C";
CCInfo ccInfo = new CCInfo();
int iCount = cSqlMapper.Instance().QueryForObject <int>("CC.SearchCount", orderSearchInfo);
IList <CCInfo> ccInfoList = new List <CCInfo>();
ccInfoList = cSqlMapper.Instance().QueryForList <CCInfo>("CC.Search", orderSearchInfo);
ccInfo.ICount = iCount;
ccInfo.CCInfoList = ccInfoList;
return(ccInfo);
}
catch (Exception ex) {
throw (ex);
}
}
/// <summary>
/// 提交盘点单据
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfo">盘点单信息</param>
/// <returns></returns>
private bool SetCCTableInfo(LoggingSessionInfo loggingSessionInfo, CCInfo ccInfo)
{
//try
//{
if (ccInfo != null)
{
if (ccInfo.data_from_id == null || ccInfo.data_from_id.Equals(""))
{
ccInfo.data_from_id = "B8DF5D46D3CA430ABE21E20F8D71E212";
}
if (ccInfo.create_user_id == null || ccInfo.create_user_id.Equals(""))
{
ccInfo.create_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.create_time = GetCurrentDateTime();
}
if (ccInfo.modify_user_id == null || ccInfo.modify_user_id.Equals(""))
{
ccInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.modify_time = GetCurrentDateTime();
}
if (ccInfo.CCDetailInfoList != null)
{
foreach (CCDetailInfo ccDetailInfo in ccInfo.CCDetailInfoList)
{
if (ccDetailInfo.order_detail_id == null || ccDetailInfo.order_detail_id.Equals(""))
{
ccDetailInfo.order_detail_id = NewGuid();
}
if (ccDetailInfo.if_flag.ToString() == null || ccDetailInfo.if_flag.ToString().Equals(""))
{
ccDetailInfo.if_flag = 0;
}
ccDetailInfo.order_id = ccInfo.order_id;
ccDetailInfo.order_no = ccInfo.order_no;
}
}
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("CC.InsertOrUpdate", ccInfo);
}
return(true);
//}
//catch (Exception ex)
//{
// strError = ex.ToString();
// throw (ex);
//}
}
/// <summary>
/// 获取单个盘点单明细
/// </summary>
/// <param name="loggingSessionInfo">登录model【必须】</param>
/// <param name="orderId">订单标识【必须】</param>
/// <param name="maxRowCount">商品明细当前页显示数量</param>
/// <param name="startRowIndex">商品明细当前页开始行</param>
/// <returns></returns>
public CCInfo GetCCInfoById(LoggingSessionInfo loggingSessionInfo, string orderId, int maxRowCount, int startRowIndex)
{
try
{
CCInfo ccInfo = new CCInfo();
Hashtable _ht = new Hashtable();
_ht.Add("OrderId", orderId);
ccInfo = (CCInfo)cSqlMapper.Instance().QueryForObject("CC.SelectById", _ht);
CCInfo ccInfo1 = new CCInfo();
ccInfo1 = GetCCDetailInfoByOrderId(loggingSessionInfo, orderId, maxRowCount, startRowIndex);
ccInfo.CCDetail_ICount = ccInfo1.CCDetail_ICount;
ccInfo.CCDetailInfoList = ccInfo1.CCDetailInfoList;
return(ccInfo);
}
catch (Exception ex) {
throw (ex);
}
}
public CCInfo GetCustomerCC(string CardId)
{
using (DiamondCircle_dbEntities db = new DiamondCircle_dbEntities())
{
var card = db.Cards.Where(c => c.CardId == CardId).FirstOrDefault();
if (card == null)
{
throw new InvalidOperationException("The card entered does not exist");
}
var creditCard = db.CreditCards.Where(cc => cc.CreditCardId == card.CreditCardId).FirstOrDefault();
if (creditCard == null)
{
throw new InvalidOperationException("This card does not have credit card details related to it.");
}
CCInfo ccDetails = new CCInfo()
{
Address = creditCard.AddressLine1,
CardHolderName = creditCard.CardHolderName,
CardNumber = creditCard.CardNumber,
City = creditCard.Suburb,
CountryName = creditCard.CountryName,
CVC2 = creditCard.CVC2,
EmailAddress = creditCard.EmailAddress,
FirstName = creditCard.FirstName,
LastName = creditCard.LastName,
State = creditCard.State,
Telephone = creditCard.Telephone,
Zip = creditCard.Postcode,
DOB = creditCard.DOB
};
if (creditCard.ExpiryDate.HasValue)
{
ccDetails.ExpiryDate = (DateTime)creditCard.ExpiryDate;
}
return(ccDetails);
}
}
/// <summary>
/// 获取单个盘点单明细
/// </summary>
/// <param name="orderId">订单标识【必须】</param>
/// <param name="maxRowCount">商品明细当前页显示数量</param>
/// <param name="startRowIndex">商品明细当前页开始行</param>
/// <returns></returns>
public CCInfo GetCCInfoById(string orderId, int maxRowCount, int startRowIndex)
{
try
{
CCInfo ccInfo = new CCInfo();
DataSet ds = ccService.GetCCInfoById(orderId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
ccInfo = DataTableToObject.ConvertToObject <CCInfo>(ds.Tables[0].Rows[0]);
}
CCInfo ccInfo1 = new CCInfo();
ccInfo1 = GetCCDetailInfoByOrderId(orderId, maxRowCount, startRowIndex);
ccInfo.CCDetail_ICount = ccInfo1.CCDetail_ICount;
ccInfo.CCDetailInfoList = ccInfo1.CCDetailInfoList;
return(ccInfo);
}
catch (Exception ex) {
throw (ex);
}
}
/// <summary>
/// 盘点单审批
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="order_id"></param>
/// <param name="billActionType"></param>
/// <returns></returns>
public bool SetCCOrderStatus(LoggingSessionInfo loggingSessionInfo, string order_id, BillActionType billActionType)
{
string strResult = string.Empty;
try
{
cPos.Service.cBillService bs = new cBillService();
BillOperateStateService state = bs.ApproveBill(loggingSessionInfo, order_id, "", billActionType);
if (state == BillOperateStateService.ApproveSuccessful)
{
//获取要改变的表单信息
BillModel billInfo = new cBillService().GetBillById(loggingSessionInfo, order_id);
//设置要改变的用户信息
CCInfo ccInfo = new CCInfo();
ccInfo.status = billInfo.Status;
ccInfo.status_desc = billInfo.BillStatusDescription;
ccInfo.order_id = order_id;
ccInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.modify_time = GetCurrentDateTime(); //获取当前时间
if (billActionType == BillActionType.Approve)
{
ccInfo.approve_time = GetCurrentDateTime();
ccInfo.approve_user_id = loggingSessionInfo.CurrentUser.User_Id;
}
//提交
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("CC.UpdateStatus", ccInfo);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 获取单个盘点单sku明细
/// </summary>
/// <param name="loggingSessionInfo">登录model【必须】</param>
/// <param name="orderId">订单标识【必须】</param>
/// <param name="maxRowCount">商品明细当前页显示数量</param>
/// <param name="startRowIndex">商品明细当前页开始行</param>
/// <returns></returns>
public CCInfo GetCCDetailInfoByOrderId(LoggingSessionInfo loggingSessionInfo, string orderId, int maxRowCount, int startRowIndex)
{
try
{
CCInfo ccInfo = new CCInfo();
IList <CCDetailInfo> ccDetailList = new List <CCDetailInfo>();
Hashtable _ht = new Hashtable();
_ht.Add("OrderId", orderId);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
int iCount = cSqlMapper.Instance().QueryForObject <int>("CCDetail.SelectByOrderIdCount", _ht);
ccDetailList = cSqlMapper.Instance().QueryForList <CCDetailInfo>("CCDetail.SelectByOrderId", _ht);
ccInfo.CCDetail_ICount = iCount;
ccInfo.CCDetailInfoList = ccDetailList;
return(ccInfo);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 获取单个盘点单sku明细
/// </summary>
/// <param name="loggingSessionInfo">登录model【必须】</param>
/// <param name="orderId">订单标识【必须】</param>
/// <param name="maxRowCount">商品明细当前页显示数量</param>
/// <param name="startRowIndex">商品明细当前页开始行</param>
/// <returns></returns>
public CCInfo GetCCDetailInfoByOrderId(string orderId, int maxRowCount, int startRowIndex)
{
try
{
CCInfo ccInfo = new CCInfo();
IList <CCDetailInfo> ccDetailList = new List <CCDetailInfo>();
int iCount = ccService.GetCCDetailCountByOrderId(orderId);
DataSet ds = new DataSet();
ds = ccService.GetCCDetailInfoListByOrderId(orderId, startRowIndex, startRowIndex + maxRowCount);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ccDetailList = DataTableToObject.ConvertToList <CCDetailInfo>(ds.Tables[0]);
}
ccInfo.CCDetail_ICount = iCount;
ccInfo.CCDetailInfoList = ccDetailList;
return(ccInfo);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 订单状态修改
/// </summary>
/// <param name="order_id"></param>
/// <param name="billActionType"></param>
/// <param name="strError"></param>
/// <returns></returns>
public bool SetCCStatusUpdate(string order_id, BillActionType billActionType, out string strError)
{
string strResult = string.Empty;
try
{
CCInfo ccInfo = new CCInfo();
ccInfo.order_id = order_id;
ccInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.modify_time = GetCurrentDateTime(); //获取当前时间
if (loggingSessionInfo.CurrentLoggingManager.IsApprove == null || loggingSessionInfo.CurrentLoggingManager.IsApprove.Equals("0"))
{
switch (billActionType)
{
case BillActionType.Cancel:
ccInfo.status = "-1";
ccInfo.status_desc = "删除";
break;
case BillActionType.Approve:
ccInfo.status = "10";
ccInfo.status_desc = "已审批";
ccInfo.approve_time = GetCurrentDateTime();
ccInfo.approve_user_id = loggingSessionInfo.CurrentUser.User_Id;
break;
case BillActionType.Reject:
ccInfo.status = "1";
ccInfo.status_desc = "未审批";
break;
case BillActionType.Create:
ccInfo.status = "1";
ccInfo.status_desc = "未审批";
break;
default:
ccInfo.status = "1";
ccInfo.status_desc = "未审批";
break;
}
}
else
{
cBillService bs = new cBillService(loggingSessionInfo);
BillOperateStateService state = bs.ApproveBill(order_id, "", billActionType, out strResult);
if (state == BillOperateStateService.ApproveSuccessful)
{
//获取要改变的表单信息
BillModel billInfo = bs.GetBillById(order_id);
//设置要改变的用户信息
ccInfo.status = billInfo.Status;
ccInfo.status_desc = billInfo.BillStatusDescription;
if (billActionType == BillActionType.Approve)
{
ccInfo.approve_time = GetCurrentDateTime();
ccInfo.approve_user_id = loggingSessionInfo.CurrentUser.User_Id;
}
}
else
{
strError = "获取状态失败--" + strResult;
return(false);
}
}
bool bReturn = ccService.SetCCStatusUpdate(ccInfo);
strError = "操作成功";
return(true);
}
catch (Exception ex)
{
strError = ex.ToString();
throw (ex);
}
}
/// <summary>
/// 处理盘点单信息（新建，修改）
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="ccInfo">盘点单model</param>
/// <param name="IsTrans">是否批处理</param>
/// <param name="strError">返回错误信息</param>
/// <returns></returns>
public bool SetCCInfo(LoggingSessionInfo loggingSessionInfo, CCInfo ccInfo, bool IsTrans, out string strError)
{
string strDo = string.Empty;
if (IsTrans)
{
cSqlMapper.Instance().BeginTransaction();
}
try
{
ccInfo.customer_id = loggingSessionInfo.CurrentLoggingManager.Customer_Id;
if (ccInfo.if_flag == null || ccInfo.if_flag.ToString().Trim().Equals(""))
{
ccInfo.if_flag = "0";
}
if (ccInfo.order_type_id == null || ccInfo.order_type_id.Equals(""))
{
ccInfo.order_type_id = "51BE351BFA5E49A490103669EA21BC3C";
}
if (ccInfo.BillKindCode == null || ccInfo.BillKindCode.Equals(""))
{
ccInfo.BillKindCode = "CC";
}
if (ccInfo.order_id == null || ccInfo.order_id.Equals(""))
{
ccInfo.order_id = NewGuid();
}
//1.判断重复
if (!IsExistOrderCode(loggingSessionInfo, ccInfo.order_no, ccInfo.order_id))
{
strError = "订单号码已经存在。";
throw (new System.Exception(strError));
}
if (ccInfo.operate == null || ccInfo.operate.Equals(""))
{
ccInfo.operate = "Create";
}
if (ccInfo.operate.Equals("Create"))
{
//2.提交表单
if (!SetInoutOrderInsertBill(loggingSessionInfo, ccInfo))
{
strError = "盘点单表单提交失败。";
throw (new System.Exception(strError));
}
//3.更改状态
BillModel billInfo = new cBillService().GetBillById(loggingSessionInfo, ccInfo.order_id);
if (billInfo != null)
{
ccInfo.status = billInfo.Status;
ccInfo.status_desc = billInfo.BillStatusDescription;
}
}
//4.提交cc与ccdetail信息
if (!SetCCTableInfo(loggingSessionInfo, ccInfo))
{
strError = "提交用户表失败";
throw (new System.Exception(strError));
}
if (IsTrans)
{
cSqlMapper.Instance().CommitTransaction();
}
strError = "保存成功!";
return(true);
}
catch (Exception ex)
{
if (IsTrans)
{
cSqlMapper.Instance().RollBackTransaction();
}
throw (ex);
}
}
/// <summary>
/// 提交盘点单据
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfo">盘点单信息</param>
/// <returns></returns>
private bool SetCCTableInfo(CCInfo ccInfo)
{
PublicService pService = new PublicService();
string sql = "";
//修改盘点单主表
#region
sql = " update t_cc set order_no = '" + ccInfo.order_no + "' ";
sql = pService.GetIsNotNullUpdateSql(sql, "order_date", ccInfo.order_date);
sql = pService.GetIsNotNullUpdateSql(sql, "order_type_id", ccInfo.order_type_id);
sql = pService.GetIsNotNullUpdateSql(sql, "order_reason_id", ccInfo.order_reason_id);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_id", ccInfo.ref_order_id);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_no", ccInfo.ref_order_no);
sql = pService.GetIsNotNullUpdateSql(sql, "request_date", ccInfo.request_date);
sql = pService.GetIsNotNullUpdateSql(sql, "complete_date", ccInfo.complete_date);
sql = pService.GetIsNotNullUpdateSql(sql, "unit_id", ccInfo.unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "pos_id", ccInfo.pos_id);
sql = pService.GetIsNotNullUpdateSql(sql, "warehouse_id", ccInfo.warehouse_id);
sql = pService.GetIsNotNullUpdateSql(sql, "remark", ccInfo.remark);
sql = pService.GetIsNotNullUpdateSql(sql, "data_from_id", ccInfo.data_from_id);
sql = pService.GetIsNotNullUpdateSql(sql, "status", ccInfo.status);
sql = pService.GetIsNotNullUpdateSql(sql, "status_desc", ccInfo.status_desc);
sql = pService.GetIsNotNullUpdateSql(sql, "create_time", ccInfo.create_time);
sql = pService.GetIsNotNullUpdateSql(sql, "create_user_id", ccInfo.create_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", ccInfo.modify_time);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", ccInfo.modify_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "send_time", ccInfo.send_time);
sql = pService.GetIsNotNullUpdateSql(sql, "send_user_id", ccInfo.send_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_time", ccInfo.approve_time);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_user_id", ccInfo.approve_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_time", ccInfo.accpect_time);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_user_id", ccInfo.accpect_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "if_flag", ccInfo.if_flag);
sql = sql + " where order_id = '" + ccInfo.order_id + "' ; ";
#endregion
//插入盘点单
#region
sql = sql + "insert into t_cc( "
+ " order_id "
+ " ,order_no "
+ " ,order_date "
+ " ,order_type_id "
+ " ,order_reason_id "
+ " ,ref_order_id "
+ " ,ref_order_no "
+ " ,request_date "
+ " ,complete_date "
+ " ,unit_id "
+ " ,pos_id "
+ " ,warehouse_id "
+ " ,remark "
+ " ,data_from_id "
+ " ,status "
+ " ,status_desc "
+ " ,create_time "
+ " ,create_user_id "
+ " ,modify_time "
+ " ,modify_user_id "
+ " ,send_time "
+ " ,send_user_id "
+ " ,approve_time "
+ " ,approve_user_id "
+ " ,accpect_time "
+ " ,accpect_user_id "
+ " ,if_flag "
+ " ,customer_id "
+ " ) "
+ " select a.* From ( "
+ " select '" + ccInfo.order_id + "' order_id "
+ " ,'" + ccInfo.order_no + "' order_no "
+ " ,'" + ccInfo.order_date + "' order_date "
+ " ,'" + ccInfo.order_type_id + "' order_type_id "
+ " ,'" + ccInfo.order_reason_id + "' order_reason_id "
+ " ,'" + ccInfo.ref_order_id + "' ref_order_id "
+ " ,'" + ccInfo.ref_order_no + "' ref_order_no "
+ " ,'" + ccInfo.request_date + "' request_date "
+ " ,'" + ccInfo.complete_date + "' complete_date "
+ " ,'" + ccInfo.unit_id + "' unit_id "
+ " ,'" + ccInfo.pos_id + "' pos_id "
+ " ,'" + ccInfo.warehouse_id + "' warehouse_id "
+ " ,'" + ccInfo.remark + "' remark "
+ " ,'" + ccInfo.data_from_id + "' data_from_id "
+ " ,'" + ccInfo.status + "' status "
+ " ,'" + ccInfo.status_desc + "' status_desc "
+ " ,'" + ccInfo.create_time + "' create_time "
+ " ,'" + ccInfo.create_user_id + "' create_user_id "
+ " ,'" + ccInfo.modify_time + "' modify_time "
+ " ,'" + ccInfo.modify_user_id + "' modify_user_id "
+ " ,'" + ccInfo.send_time + "' send_time "
+ " ,'" + ccInfo.send_user_id + "' send_user_id "
+ " ,'" + ccInfo.approve_time + "' approve_time "
+ " ,'" + ccInfo.approve_user_id + "' approve_user_id "
+ " ,'" + ccInfo.accpect_time + "' accpect_time "
+ " ,'" + ccInfo.accpect_user_id + "' accpect_user_id "
+ " ,'" + ccInfo.if_flag + "' if_flag "
+ " ,'" + ccInfo.customer_id + "' customer_id "
+ " ) a "
+ " left join T_cc b "
+ " on(a.order_id = b.order_id) "
+ " where b.order_id is null ; ";
#endregion
//删除盘点单明细
#region
sql = sql + "delete t_cc_detail where order_id = '" + ccInfo.order_id + "' ;";
#endregion
//插入明细
if (ccInfo.CCDetailInfoList != null)
{
foreach (CCDetailInfo ccDetailInfo in ccInfo.CCDetailInfoList)
{
#region
sql = sql + "insert into t_cc_detail "
+ " ( "
+ " order_detail_id "
+ " ,order_id "
+ " ,ref_order_detail_id "
+ " ,order_no "
+ " ,stock_balance_id "
+ " ,sku_id "
+ " ,warehouse_id "
+ " ,end_qty "
+ " ,order_qty "
+ " ,remark "
+ " ,display_index "
+ " ,create_time "
+ " ,create_user_id "
+ " ,modify_time "
+ " ,modify_user_id "
+ " ,if_flag "
+ " ) "
+ " SELECT '" + ccDetailInfo.order_detail_id + "' order_detail_id "
+ " ,'" + ccDetailInfo.order_id + "' order_id "
+ " ,'" + ccDetailInfo.ref_order_detail_id + "' ref_order_detail_id "
+ " ,'" + ccDetailInfo.order_no + "' order_no "
+ " ,'" + ccDetailInfo.stock_balance_id + "' stock_balance_id "
+ " ,'" + ccDetailInfo.sku_id + "' sku_id "
+ " ,'" + ccDetailInfo.warehouse_id + "' warehouse_id "
+ " ,'" + ccDetailInfo.end_qty + "' end_qty "
+ " ,'" + ccDetailInfo.order_qty + "' order_qty "
+ " ,'" + ccDetailInfo.remark + "' remark "
+ " ,'" + ccDetailInfo.display_index + "' display_index "
+ " ,'" + ccDetailInfo.create_time + "' create_time "
+ " ,'" + ccDetailInfo.create_user_id + "' create_user_id "
+ " ,'" + ccDetailInfo.modify_time + "' modify_time "
+ " ,'" + ccDetailInfo.modify_user_id + "' modify_user_id "
+ " ,'" + ccDetailInfo.if_flag + "' if_flag ;";
#endregion
}
}
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 盘点单保存
/// </summary>
/// <param name="ccInfo"></param>
/// <param name="IsTrans"></param>
/// <param name="strError"></param>
/// <returns></returns>
public bool SetCCInfo(CCInfo ccInfo, bool IsTrans, out string strError)
{
using (IDbTransaction tran = this.SQLHelper.CreateTransaction())
{
try
{
if (ccInfo.CCInfoList != null)
{
foreach (CCInfo ccInfo1 in ccInfo.CCInfoList)
{
//1.判断重复
if (!IsExistOrderCode(ccInfo1.order_no, ccInfo1.order_id))
{
strError = "订单号码已经存在。";
throw (new System.Exception(strError));
}
if (ccInfo1.operate.Equals("Create"))
{
if (loggingSessionInfo.CurrentLoggingManager.IsApprove == null || loggingSessionInfo.CurrentLoggingManager.IsApprove.Equals("0"))
{
ccInfo1.status = "1";
ccInfo1.status_desc = "未审批";
}
else
{
//2.提交表单
if (!SetInoutOrderInsertBill(ccInfo))
{
strError = "盘点单表单提交失败。";
throw (new System.Exception(strError));
}
//3.更改状态
DataSet ds = new BillService(loggingSessionInfo).GetBillById(ccInfo1.order_id);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
ccInfo1.status = ds.Tables[0].Rows[0]["Status"].ToString();
ccInfo.status_desc = ds.Tables[0].Rows[0]["BillStatusDescription"].ToString();
}
}
}
//4.提交cc与ccdetail信息
if (!SetCCTableInfo(ccInfo1))
{
strError = "提交主表失败";
throw (new System.Exception(strError));
}
}
}
tran.Commit();
strError = "成功";
return(true);
}
catch (Exception ex)
{
tran.Rollback();
throw (ex);
}
}
}
/// <summary>
/// 获取库存盘点单明细
/// </summary>
public string GetCcDetailInfoById()
{
var ccService = new CCService(CurrentUserInfo);
IList <CCDetailInfo> data = null;
string content = string.Empty;
string order_id = string.Empty;
string unit_id = string.Empty;
string warehouse_id = string.Empty;
if (FormatParamValue(Request("order_id")) != null && FormatParamValue(Request("order_id")) != string.Empty)
{
order_id = FormatParamValue(Request("order_id")).ToString().Trim();
}
if (FormatParamValue(Request("unit_id")) != null && FormatParamValue(Request("unit_id")) != string.Empty)
{
unit_id = FormatParamValue(Request("unit_id")).ToString().Trim();
}
if (FormatParamValue(Request("warehouse_id")) != null && FormatParamValue(Request("warehouse_id")) != string.Empty)
{
warehouse_id = FormatParamValue(Request("warehouse_id")).ToString().Trim();
}
int maxRowCount = 100000;
int startRowIndex = 0;
if (order_id == null || order_id.Trim().Length == 0)
{
order_id = string.Empty;
}
CCInfo order = null;
CCDetailInfo dataStock = null;
if (order_id.Trim().Length > 0)
{
order = ccService.GetCCDetailInfoByOrderId(order_id, maxRowCount, startRowIndex);
}
else if (unit_id.Trim().Length > 0 && warehouse_id.Trim().Length > 0)
{
dataStock = ccService.GetCCDetailListStockBalance(CurrentUserInfo,
order_id,
unit_id,
warehouse_id,
maxRowCount,
startRowIndex);
}
if (order != null)
{
data = order.CCDetailInfoList;
foreach (var detailItem in order.CCDetailInfoList)
{
detailItem.display_name = SkuService.GetItemAllName(detailItem);
}
}
else if (dataStock != null)
{
data = dataStock.CCDetailInfoList;
foreach (var detailItem in dataStock.CCDetailInfoList)
{
detailItem.display_name = SkuService.GetItemAllName(detailItem);
}
}
content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}",
data.ToJSON(),
data.Count);
return(content);
}
/// <summary>
/// 保存库存盘点单
/// </summary>
public string SaveCcOrder()
{
var inoutService = new CCService(CurrentUserInfo);
CCInfo order = new CCInfo();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string order_id = string.Empty;
if (FormatParamValue(Request("order")) != null && FormatParamValue(Request("order")) != string.Empty)
{
key = FormatParamValue(Request("order")).ToString().Trim();
}
if (FormatParamValue(Request("order_id")) != null && FormatParamValue(Request("order_id")) != string.Empty)
{
order_id = FormatParamValue(Request("order_id")).ToString().Trim();
}
order = key.DeserializeJSONTo <CCInfo>();
if (order_id.Trim().Length == 0)
{
order.order_id = Utils.NewGuid();
}
else
{
order.order_id = order_id;
}
if (order.order_no == null || order.order_no.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "单据号码不能为空";
return(responseData.ToJSON());
}
if (order.order_date == null || order.order_date.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "单据日期不能为空";
return(responseData.ToJSON());
}
if (order.complete_date == null || order.complete_date.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "入库日期不能为空";
return(responseData.ToJSON());
}
if (order.unit_id == null || order.unit_id.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "盘点单位不能为空";
return(responseData.ToJSON());
}
if (order.warehouse_id == null || order.warehouse_id.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "仓库不能为空";
return(responseData.ToJSON());
}
if (order.CCDetailInfoList == null || order.CCDetailInfoList.Count == 0)
{
responseData.success = false;
responseData.msg = "商品不能为空";
return(responseData.ToJSON());
}
inoutService.SetCCInfo(order, false, out error);
responseData.success = true;
responseData.msg = error;
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 处理盘点单信息（新建，修改）
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="ccInfo">盘点单model</param>
/// <param name="IsTrans">是否批处理</param>
/// <param name="strError">返回错误信息</param>
/// <returns></returns>
public bool SetCCInfo(CCInfo ccInfo, bool IsTrans, out string strError)
{
ccInfo.customer_id = loggingSessionInfo.CurrentLoggingManager.Customer_Id;
if (ccInfo.if_flag == null || ccInfo.if_flag.ToString().Trim().Equals(""))
{
ccInfo.if_flag = "0";
}
if (ccInfo.order_type_id == null || ccInfo.order_type_id.Equals(""))
{
ccInfo.order_type_id = "51BE351BFA5E49A490103669EA21BC3C";
}
if (ccInfo.BillKindCode == null || ccInfo.BillKindCode.Equals(""))
{
ccInfo.BillKindCode = "CC";
}
if (ccInfo.order_id == null || ccInfo.order_id.Equals(""))
{
ccInfo.order_id = NewGuid();
}
if (ccInfo.data_from_id == null || ccInfo.data_from_id.Equals(""))
{
ccInfo.data_from_id = "B8DF5D46D3CA430ABE21E20F8D71E212";
}
if (ccInfo.create_user_id == null || ccInfo.create_user_id.Equals(""))
{
ccInfo.create_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.create_time = GetCurrentDateTime();
}
if (ccInfo.modify_user_id == null || ccInfo.modify_user_id.Equals(""))
{
ccInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
ccInfo.modify_time = GetCurrentDateTime();
}
CCInfo ccInfo1 = new CCInfo();
ccInfo1 = GetCCInfoById(ccInfo.order_id, 10000, 0);
if (ccInfo1 == null || ccInfo1.order_id == null || ccInfo1.order_id.Equals(""))
{
ccInfo.operate = "Create";
}
else
{
ccInfo.operate = "Modify";
}
if (ccInfo.operate == null || ccInfo.operate.Equals(""))
{
ccInfo.operate = "Create";
}
if (ccInfo.CCDetailInfoList != null)
{
foreach (CCDetailInfo ccDetailInfo in ccInfo.CCDetailInfoList)
{
if (ccDetailInfo.order_detail_id == null || ccDetailInfo.order_detail_id.Equals(""))
{
ccDetailInfo.order_detail_id = NewGuid();
}
if (ccDetailInfo.if_flag.ToString() == null || ccDetailInfo.if_flag.ToString().Equals(""))
{
ccDetailInfo.if_flag = 0;
}
ccDetailInfo.order_id = ccInfo.order_id;
ccDetailInfo.order_no = ccInfo.order_no;
ccDetailInfo.create_time = GetCurrentDateTime();
ccDetailInfo.create_user_id = loggingSessionInfo.CurrentUser.User_Id;
}
}
IList <CCInfo> ccInfoList = new List <CCInfo>();
ccInfoList.Add(ccInfo);
ccInfo.CCInfoList = ccInfoList;
bool bReturn = ccService.SetCCInfo(ccInfo, IsTrans, out strError);
return(false);
}
public virtual ICustomerMod CreditCardInfo(CCInfo creditCard)
{
AddCCInfo("CreditCardInfo", creditCard);
return(this);
}
/// <summary>
/// 检查CCOrder是否已存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckExistCCOrder(CCInfo model)
{
int count = MSSqlMapper.Instance().QueryForObject <int>("CCOrder.CheckExistCCOrder", model);
return(count > 0 ? true : false);
}
