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