/// <summary>
/// 加载主表明细数据
/// </summary>
public void LoadMAIN()
{
string _tbxTAKEIN_ID = tbxTAKEIN_ID.Text;
if (!String.IsNullOrEmpty(_tbxTAKEIN_ID))
{
var model = new TAKEIN10(x => x.TAKEIN_ID == _tbxTAKEIN_ID);
ddlSHOP_NAME.SelectedValue = model.SHOP_ID;
dpINPUT_DATE.SelectedDate = model.INPUT_DATE;
ddlStatus.SelectedValue = model.STATUS.ToString();
ddlSUP_ID.SelectedValue = model.SUP_ID;
ddlSTOCK_ID.SelectedValue = model.STOCK_ID;
tbxUSER_ID.Text = model.USER_ID;
tbxAPP_USER.Text = model.APP_USER;
tbxAPP_DATETIME.Text = model.APP_DATETIME.ToString("yyyy-MM-dd HH:mm:ss") == "1900-01-01 00:00:00" ? "" : model.APP_DATETIME.ToString("yyyy-MM-dd HH:mm:ss");
tbxRELATE_ID.Text = model.RELATE_ID;
tbxMemo.Text = model.Memo;
ckLOCKED.Checked = model.LOCKED == 0 ? true : false;
if (!String.IsNullOrEmpty(model.RELATE_ID))
{
ButtonYR.Enabled = false;
}
tbxTOT_AMOUNT.Text = model.TOT_AMOUNT.ToString();
tbxTOT_QTY.Text = model.TOT_QTY.ToString();
tbxTOT_TAX.Text = model.TOT_TAX.ToString();
tbxCRT_DATETIME.Text = model.CRT_DATETIME.ToString();
tbxCRT_USER_ID.Text = model.CRT_USER_ID;
tbxMOD_DATETIME.Text = model.MOD_DATETIME.ToString();
tbxMOD_USER_ID.Text = model.MOD_USER_ID;
//tbxLAST_UPDATE.Text = model.LAST_UPDATE.ToString();
OrderStatus(model);
}
}
/// <summary>
/// 加载主表明细数据
/// </summary>
public void LoadTAKEN10()
{
string _takein_id = tbxTAKEIN_ID.Text;
if (!String.IsNullOrEmpty(_takein_id))
{
var model = new TAKEIN10(x => x.TAKEIN_ID == _takein_id);
ddlSHOP_NAME.SelectedValue = model.SHOP_ID;
dpINPUT_DATE.SelectedDate = model.INPUT_DATE;
ddlStatus.SelectedValue = model.STATUS.ToString();
ddlSTOCK_ID.SelectedValue = model.STOCK_ID;
ddlSUP_NAME.SelectedValue = model.SUP_ID;
tbxUSER_ID.Text = model.USER_ID;
tbxAPP_USER.Text = model.APP_USER;
numTOT_AMOUNT.Text = model.TOT_AMOUNT.ToString();
numTOT_TAX.Text = model.TOT_TAX.ToString();
numTOT_QTY.Text = model.TOT_QTY.ToString();
numPRE_PAY.Text = model.PRE_PAY.ToString();
tbxPRE_PAY_ID.Text = model.PRE_PAY_ID.ToString();
tbxRELATE_ID.Text = model.RELATE_ID.ToString();
tbxINVOICE_ID.Text = model.INVOICE_ID.ToString();
ddlTAKEIN_TYPE.SelectedValue = model.TAKEIN_TYPE.ToString();
ckLOCKED.Checked = model.LOCKED == '0'? false : true;
tbxMemo.Text = model.Memo;
tbxCRT_DATETIME.Text = model.CRT_DATETIME.ToString();
tbxCRT_USER_ID.Text = model.CRT_USER_ID;
tbxMOD_DATETIME.Text = model.MOD_DATETIME.ToString();
tbxMOD_USER_ID.Text = model.MOD_USER_ID;
tbxLAST_UPDATE.Text = model.LAST_UPDATE.ToString();
OrderStatus(model.STATUS);
}
}
/// <summary>
/// 主表保存
/// </summary>
/// <returns></returns>
public string TAKEN10Edit()
{
string _takein_id = tbxTAKEIN_ID.Text;
try
{
var model = new TAKEIN10(x => x.TAKEIN_ID == _takein_id);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string _SHOP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_takein_id))
{
model.SetIsNew(true);
model.CRT_DATETIME = DateTime.Now;
model.CRT_USER_ID = OlUser.Manager_LoginName;
DataTable dt = new DataTable();
dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "TAKEN10").ExecuteDataTable();
_takein_id = dt.Rows[0]["PLANE_ID"].ToString();
//var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id);
}
model.SHOP_ID = _SHOP_ID;
model.TAKEIN_ID = _takein_id.ToString();
model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue);
model.STOCK_ID = ddlSTOCK_ID.SelectedValue;
//model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString());
model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString());
model.SUP_ID = ddlSUP_NAME.SelectedValue;
model.USER_ID = OlUser.Manager_LoginName;
model.APP_USER = OlUser.Manager_LoginName;
model.APP_DATETIME = DateTime.Now;
model.TOT_AMOUNT = ConvertHelper.StringToDecimal(numTOT_AMOUNT.Text);
model.TOT_TAX = ConvertHelper.StringToDecimal(numTOT_QTY.Text);
model.TOT_QTY = ConvertHelper.StringToDecimal(numPRE_PAY.Text);
model.PRE_PAY = ConvertHelper.StringToDecimal(numPRE_PAY.Text);
model.PRE_PAY_ID = tbxPRE_PAY_ID.Text;
model.RELATE_ID = tbxRELATE_ID.Text;
model.INVOICE_ID = tbxINVOICE_ID.Text;
model.TAKEIN_TYPE = ConvertHelper.Cint(ddlTAKEIN_TYPE.SelectedValue);
model.Memo = tbxMemo.Text;
model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0");
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.LAST_UPDATE = DateTime.Now;
model.Trans_STATUS = 0;
TAKEIN10Bll.GetInstence().Save(this, model);
}
catch (Exception err)
{
return(err.Message);
}
return("");
}
/// <summary>
/// 作废按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void Btn_MainCancel(Object sender, EventArgs e)
{
string _TAKEIN_ID = tbxTAKEIN_ID.Text.ToString();
var model = TAKEIN10.SingleOrDefault(x => x.TAKEIN_ID == _TAKEIN_ID);
if (model == null)
{
FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information);
}
//1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货)
switch (model.STATUS)
{
case 1: model.STATUS = 3; break;
case 2: FineUI.Alert.ShowInParent("订单已核准，无法进行作废", FineUI.MessageBoxIcon.Information); return;
case 3: model.STATUS = 1; break;
case 4: FineUI.Alert.ShowInParent("订单已引入，无法进行作废", FineUI.MessageBoxIcon.Information); return;
default: FineUI.Alert.ShowInParent("订单状态有误，无法进行作废", FineUI.MessageBoxIcon.Information); return;
}
ddlStatus.SelectedValue = model.STATUS.ToString();
string result = DetailEdit();
if (String.IsNullOrEmpty(result))
{
result = MAINEdit();
}
if (!String.IsNullOrEmpty(result))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
}
else
{
string alterMssage = ButtonCancel.Text;
if (alterMssage == "取消作废")
{
FineUI.Alert.ShowInParent("作废成功", FineUI.MessageBoxIcon.Error);
}
else
{
FineUI.Alert.ShowInParent("取消作废成功", FineUI.MessageBoxIcon.Error);
}
}
//FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information);
}
/// <summary>
/// 核准按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void Btn_MainCheck(Object sender, EventArgs e)
{
string _TAKEIN_ID = tbxTAKEIN_ID.Text.ToString();
var model = TAKEIN10.SingleOrDefault(x => x.TAKEIN_ID == _TAKEIN_ID);
if (model == null)
{
FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information);
return;
}
//1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货)
switch (model.STATUS)
{
case 1: model.STATUS = 2; break;
case 2: model.STATUS = 1; break;
case 3: FineUI.Alert.ShowInParent("订单已作废，无法进行核准", FineUI.MessageBoxIcon.Information); return;
case 4: FineUI.Alert.ShowInParent("订单已引入，无法进行核准", FineUI.MessageBoxIcon.Information); return;
default: FineUI.Alert.ShowInParent("订单状态有误，无法核准", FineUI.MessageBoxIcon.Information); return;
}
ddlStatus.SelectedValue = model.STATUS.ToString();
string result = TAKEN11Edit();
if (String.IsNullOrEmpty(result))
{
result = TAKEN10Edit();
}
if (!String.IsNullOrEmpty(result))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
}
else
{
FineUI.Alert.ShowInParent("保存成功", FineUI.MessageBoxIcon.Error);
}
LoadTAKEN10();
LoadTAKEN11();
//FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
//FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information);
}
/// <summary>
/// 订单未引入出货单的情况
/// </summary>
/// <param name="model"></param>
public void OrderStatus1(TAKEIN10 model)
{
var _TAKEIN_ID = model.TAKEIN_ID;
var model2 = new Purchase00(x => x.EXPORTED_ID == _TAKEIN_ID);
if (model2.Id > 0)
{
Grid2ColumnEdit(2);
ButtonYR.Text = "取消引入";
Toolbar21111.Enabled = false;
return;
}
else
{
Grid2ColumnEdit(1);
ButtonYR.Text = "引入";
Toolbar21111.Enabled = true;
return;
}
}
/// <summary>
/// 主表保存
/// </summary>
/// <returns></returns>
public string MAINEdit()
{
string _TAKEIN_ID = tbxTAKEIN_ID.Text;
try
{
var model = new TAKEIN10(x => x.TAKEIN_ID == _TAKEIN_ID);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string _SHOP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_TAKEIN_ID))
{
model.SetIsNew(true);
model.CRT_DATETIME = DateTime.Now;
model.CRT_USER_ID = OlUser.Manager_LoginName;
DataTable dt = new DataTable();
dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "TAKEIN10").ExecuteDataTable();
_TAKEIN_ID = dt.Rows[0]["PLANE_ID"].ToString();
tbxTAKEIN_ID.Text = _TAKEIN_ID;
//var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id);
}
model.SHOP_ID = _SHOP_ID;
model.TAKEIN_ID = _TAKEIN_ID.ToString();
model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue);
model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString());
if (String.IsNullOrEmpty(ddlSUP_ID.SelectedValue))
{
model.SUP_ID = "";
}
else
{
model.SUP_ID = ddlSUP_ID.SelectedValue;
}
model.STOCK_ID = ddlSTOCK_ID.SelectedValue;
model.USER_ID = OlUser.Manager_LoginName;
model.APP_USER = OlUser.Manager_LoginName;
model.APP_DATETIME = tbxAPP_DATETIME.Text == "" ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Now;
string _RELATE_ID = tbxRELATE_ID.Text;
model.RELATE_ID = _RELATE_ID;
//if (!String.IsNullOrEmpty(_RELATE_ID))
//{
// var modelOrder = new OUT_BACK00(x => x.BK_ID == _RELATE_ID);
// modelOrder.Exported = 1;
// modelOrder.Exported_ID = _TAKEIN_ID;
// modelOrder.Save();
//}
model.Memo = tbxMemo.Text;
model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0");
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.LAST_UPDATE = DateTime.Now;
model.Trans_STATUS = 0;
TAKEIN10Bll.GetInstence().Save(this, model);
LoadMAIN();
}
catch (Exception err)
{
return(err.Message);
}
return("");
}
///// <summary>
///// 修改按钮
///// </summary>
//public void Btn_MainEdit(Object sender, EventArgs e)
//{
// string result = DetailEdit();
// if (String.IsNullOrEmpty(result))
// {
// result = MAINEdit();
// }
// if (!String.IsNullOrEmpty(result))
// {
// FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
// }
// else
// {
// FineUI.Alert.ShowInParent("修改成功", FineUI.MessageBoxIcon.Error);
// }
//}
/// <summary>
/// 核准按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void Btn_MainCheck(Object sender, EventArgs e)
{
string _TAKEIN_ID = tbxTAKEIN_ID.Text.ToString();
var model = TAKEIN10.SingleOrDefault(x => x.TAKEIN_ID == _TAKEIN_ID);
int in_status = model.STATUS;
if (model == null)
{
FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information);
return;
}
if (model.STATUS == 1)
{
DataTable dsCom = (DataTable)SPs.Get_MAX_Inventory_DATE().ExecuteDataTable();
DateTime dtInput = DateTime.Parse(dsCom.Rows[0]["INPUT_DATE"].ToString());
if (model.INPUT_DATE.CompareTo(dtInput) <= 0)
{
FineUI.Alert.ShowInParent("单据小于盘点日期，不允许盘点。盘点日期为:" + dsCom.Rows[0]["INPUT_DATE"].ToString() + "", FineUI.MessageBoxIcon.Information);
return;
}
}
//1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货)
switch (model.STATUS)
{
case 1: model.STATUS = 2; break;
case 2: model.STATUS = 1; break;
case 3: FineUI.Alert.ShowInParent("订单已作废，无法进行核准", FineUI.MessageBoxIcon.Information); return;
case 4: FineUI.Alert.ShowInParent("订单已引入，无法进行核准", FineUI.MessageBoxIcon.Information); return;
default: FineUI.Alert.ShowInParent("订单状态有误，无法核准", FineUI.MessageBoxIcon.Information); return;
}
ddlStatus.SelectedValue = model.STATUS.ToString();
string result = DetailEdit();
if (String.IsNullOrEmpty(result))
{
tbxAPP_DATETIME.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
result = MAINEdit();
}
if (String.IsNullOrEmpty(result))
{
//dsCom = (DataSet)SPs.Get_Purchase00(st, et, type).ExecuteDataSet();
//更新库存，厂商验收入库是否需要更新库存，待定
if (in_status == 2)
{
//SPs.Update_in_back00_stock01(_TAKEIN_ID).Execute();
}
else
{
//SPs.Update_in_back00_stock01_cancel(_TAKEIN_ID).Execute();
}
}
if (!String.IsNullOrEmpty(result))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
}
else
{
string alterMssage = ButtonCheck.Text;
if (alterMssage == "反核准")
{
FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Error);
}
else
{
FineUI.Alert.ShowInParent("取消核准成功", FineUI.MessageBoxIcon.Error);
}
}
}
public void OrderStatus2(TAKEIN10 model)
{
//1:存档 2：核准 3：作废 4：已引入
//新增：ButtonAdd 保存：ButtonSave 更新：ButtonUpdate 核准：ButtonCheck 作废：ButtonCancel
//Pur02新增：ButtonPur02Add
Grid2ColumnEdit(model.STATUS);
switch (model.STATUS)
{
case 1:
ButtonSave.Enabled = true;
ButtonCancel.Enabled = true;
ButtonCheck.Enabled = true;
ButtonYR.Enabled = true;
ButtonCheck.Text = "核准";
ButtonCancel.Text = "作废";
//ButtonDetailAdd.Enabled = true;
break;
case 2:
ButtonSave.Enabled = false;
ButtonCheck.Text = "反核准";
ButtonYR.Enabled = false;
ButtonCancel.Text = "作废";
ButtonCancel.Enabled = false;
ButtonCheck.Enabled = true;
break;
case 3:
ButtonSave.Enabled = false;
ButtonCheck.Text = "核准";
ButtonYR.Enabled = false;
ButtonCheck.Enabled = false;
ButtonCancel.Text = "取消作废";
ButtonCancel.Enabled = true;
break;
case 4:
ButtonSave.Enabled = false;
//ButtonEdit.Enabled = false;
ButtonCheck.Text = "反核准";
ButtonYR.Enabled = false;
ButtonCancel.Text = "作废";
ButtonCancel.Enabled = false;
ButtonCheck.Enabled = false;
break;
default:
ButtonSave.Enabled = false;
ButtonCheck.Text = "核准";
ButtonYR.Enabled = false;
ButtonCancel.Text = "作废";
ButtonCancel.Enabled = false;
ButtonCheck.Enabled = false;
break;
}
//判断子表是否已经产生数据，数据已经产生，则无法引入
var model2 = new TAKEIN11(x => x.TAKEIN_ID == model.TAKEIN_ID);
if (!(model2 == null || String.IsNullOrEmpty(model2.TAKEIN_ID)))
{
ButtonYR.Enabled = false;
}
}
/// <summary>
/// 状态位的判定
/// </summary>
/// <param name="status"></param>
public void OrderStatus(TAKEIN10 model)
{
OrderStatus2(model);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Preview_Ok_Click(object sender, EventArgs e)
{
//获取登录用户
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//登录名
string userId = OlUser.Manager_LoginName;
Grid previewGrid = archivePreviewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid;
int[] seelctedRows = previewGrid.SelectedRowIndexArray;
if (seelctedRows == null || seelctedRows.Length == 0)
{
Alert.Show("请选择需要确认的账单!");
return;
}
int total = 0;
foreach (int rowIndex in seelctedRows)
{
long id = (long)previewGrid.DataKeys[rowIndex][0];
try
{
int retValue = updaterHelper.Update(string.Format("update TAKEIN10 set STATUS = 5, LOCKED = 1 where Id = {0}", id));
if (retValue == 1)
{
//查询进货单主信息
List <ConditionFun.SqlqueryCondition> where = new List <ConditionFun.SqlqueryCondition>();
where.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, id, false, false));
TAKEIN10 tAKEIN10 = selectHelper.SelectSingle <TAKEIN10>(true, null, where, null);
if (tAKEIN10 == null)
{
CommonBll.WriteLog("", null);
continue;
}
List <ConditionFun.SqlqueryCondition> condition = new List <ConditionFun.SqlqueryCondition>();
condition.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "TAKEIN_ID", Comparison.Equals, id, false, false));
List <TAKEIN11> itemList = selectHelper.Select <TAKEIN11>(false, 5000, null, 0, 5000, condition, null).ExecuteTypedList <TAKEIN11>();
decimal amount = 0;
decimal tax = 0;
//
foreach (TAKEIN11 item in itemList)
{
DUE01 payItem = new DUE01();
//批次号
payItem.BAT_NO = item.BAT_NO;
//采购金额
payItem.COST = item.STD_PRICE * item.STD_QUAN;
//税额
payItem.TAX = item.Tax;
//采购金额
amount += payItem.COST;
tax += payItem.TAX;
}
DUE00 payMain = new DUE00();
//进货单审核日期
payMain.APP_DATETIME = tAKEIN10.APP_DATETIME;
//进货单审核人
payMain.APP_USER = tAKEIN10.APP_USER;
//应付账单创建日期
payMain.CRT_DATETIME = DateTime.Now;
//应付账单创建人
payMain.CRT_USER_ID = userId;
//进货单日期
payMain.INPUT_DATE = tAKEIN10.INPUT_DATE;
//发票
payMain.INVOICE_ID = tAKEIN10.INVOICE_ID;
//应付账单最后修改日期
payMain.LAST_UPDATE = DateTime.Now;
//备注
payMain.Memo = tAKEIN10.Memo;
//更新时间
payMain.MOD_DATETIME = DateTime.Now;
//修改人
payMain.MOD_USER_ID = userId;
//预付款
payMain.PRE_PAY = tAKEIN10.PRE_PAY;
//预付款单号
payMain.PRE_PAY_ID = tAKEIN10.PRE_PAY_ID;
//关联ID
payMain.RELATE_ID = tAKEIN10.RELATE_ID;
//进货分店编号
payMain.SHOP_ID = tAKEIN10.SHOP_ID;
//待核准状态
payMain.STATUS = 1;
//供应商编号
payMain.SUP_ID = tAKEIN10.SUP_ID;
//进货单号
payMain.TAKEIN_ID = tAKEIN10.TAKEIN_ID;
//进货类型
payMain.TAKEIN_TYPE = 1; //一般进货
//进货单金额
payMain.TOT_AMOUNT = amount;
//进货单数量
payMain.TOT_QTY = tAKEIN10.TOT_QTY;
//税额
payMain.TOT_TAX = tax;
payMain.USER_ID = userId;
//保存主信息
payMain.Save();
total++;
}
}
catch (Exception ex)
{
CommonBll.WriteLog(string.Format("处理进货单[{0}]发生异常", id), ex);
}
Alert.Show(string.Format("汇整完成，总共{0}条，成功{1}条", seelctedRows.Length, total));
}
}
