/// <summary>
/// 主表保存
/// </summary>
/// <returns></returns>
public string MAINEdit()
{
string _IB_ID = tbxIB_ID.Text;
try
{
var model = new IN_BACK00(x => x.IB_ID == _IB_ID);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string _SHOP_ID = ddlSHOP_NAME.SelectedValue;
if (String.IsNullOrEmpty(_IB_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, "IN_BACK00").ExecuteDataTable();
_IB_ID = dt.Rows[0]["PLANE_ID"].ToString();
//var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id);
}
model.SHOP_ID = _SHOP_ID;
model.IB_ID = _IB_ID.ToString();
model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue);
model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString());
model.OUT_SHOP = ddlOUT_SHOP.SelectedValue;
model.STOCK_ID = ddlSTOCK_ID.SelectedValue;
model.USER_ID = OlUser.Manager_LoginName;
model.APP_USER = OlUser.Manager_LoginName;
model.APP_DATETIME = 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 = _IB_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;
IN_BACK00Bll.GetInstence().Save(this, model);
}
catch (Exception err)
{
return(err.Message);
}
return("");
}
/// <summary>读取数据</summary>
public override void LoadData()
{
//设置排序
if (sortList == null)
{
Sort(null);
}
//绑定Grid表格
OnlineUsersBll.GetInstence().BindGrid(Grid1, Grid1.PageIndex + 1, Grid1.PageSize, null, sortList);
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
JArray jarr = Grid2.GetMergedData();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string result = "";
int n = 0;
for (int i = 0; i < jarr.Count; i++)
{
try
{
int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString());
var model2 = new Inventory01(x => x.Id == id);
//string str = jarr[i]["status"].ToString();
if (jarr[i]["status"].ToString().Equals("modified"))
{
model2.SetIsNew(false);
}
//else if (jarr[i]["status"].ToString().Equals("unchanged"))
//{
// continue;
//}
else
{
model2.SetIsNew(true);
}
model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString();
if (!String.IsNullOrEmpty(tbxINV_ID.Text))
{
model2.INV_ID = tbxINV_ID.Text;
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.Cdbl(jarr[i]["values"]["QUANTITY01"].ToString());
model2.QUAN = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN01"].ToString());
model2.QUAN1 = ConvertHelper.Cint(jarr[i]["values"]["QUAN101"].ToString());
model2.QUAN2 = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN201"].ToString());
model2.QUAN_B = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN_B01"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
Inventory01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
LoadDETAIL();
return(result);
}
/// <summary>读取数据</summary>
public override void LoadData()
{
string shop_id = SHOP_hidId.Text.Trim();
int managerId = OnlineUsersBll.GetInstence().GetManagerId();//获取登录名
//表头
SHOP00Bll.GetInstence().BandDropDownListShowShop(this, ddlShop, shop_id); //分店名称
SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, ddlOUT_SHOP); //供货分店
// ORDER_DEP00Bll.GetInstence().BandDropDownList(this, ddlORDER_DEP, shop_id);//订货部门
BranchBll.GetInstence().BandDropDownList(this, ddlORDER_DEP);
HiddenDep_Id.Text = ddlORDER_DEP.SelectedValue;
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
txtCRT_USER_ID.Text = manager_LoginName;
txtORD_USER.Text = manager_LoginName;
txtAPP_USER.Text = manager_LoginName;
txtMOD_USER_ID.Text = manager_LoginName;
txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间
txtManage.Text = manager_LoginName;
ddlStatus.SelectedValue = "0";//状态
ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1);
txtCRT_DATETIME.SelectedDate = DateTime.Now;
txtMOD_DATETIME.SelectedDate = DateTime.Now;
txtEXPORTED_ID.Text = "";
txtMemo.Text = "";
cbTrans_STATUS.Checked = false;
DataTable table = GetSourceData("", "");
Grid1.DataSource = table;
Grid1.DataBind();
///grid2
// string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
// conditionList = new List<ConditionFun.SqlqueryCondition>();
// conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false));
// ORDER00Bll.GetInstence().BindGrid(Grid2, 0, sortList);
// bll.BindGrid(Grid2, 0, sortList);
// ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList);
//------------------
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
//检测用户是否超时退出
OnlineUsersBll.GetInstence().IsTimeOut();
//检测用户登录的有效性（是否被系统踢下线或管理员踢下线）
if (OnlineUsersBll.GetInstence().IsOffline(this))
{
return;
}
if (!IsPostBack)
{
//检测当前页面是否有访问权限
MenuInfoBll.GetInstence().CheckPagePower(this);
#region 设置页面按键权限
try
{
//定义按键控件
Control btnControl = null;
//找到页面放置按键控件的位置
ControlCollection controls = MenuInfoBll.GetInstence().GetControls(this.Controls, "toolBar");
//逐个读取出来
for (int i = 0; i < controls.Count; i++)
{
//取出控件
btnControl = controls[i];
//判断是否除了刷新、查询和关闭以外的按键
if (btnControl.ID != "ButtonRefresh" && btnControl.ID != "ButtonSearch" && btnControl.ID != "ButtonClose" && btnControl.ID != "ButtonReset")
{
//是的话检查该按键当前用户是否有控件权限，没有的话则禁用该按键
((FineUI.Button)btnControl).Enabled = MenuInfoBll.GetInstence().CheckControlPower(this, btnControl.ID);
}
}
}
catch (Exception) { }
#endregion
//记录用户当前所在的页面位置
CommonBll.UserRecord(this);
}
//运行UI页面初始化函数，子类继承后需要重写本函数，以提供给本初始化函数调用
Init();
//如果列表项不为空时，绑定空数据显示内容
if (grid != null)
{
grid.EmptyText = String.Format("<img src=\"{0}\" alt=\"No Data Found!\"/>", ResolveUrl("/WebManage/Images/no_data_found.jpg"));
}
}
/// <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 = previewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid;
int[] seelctedRows = previewGrid.SelectedRowIndexArray;
if (seelctedRows == null || seelctedRows.Length == 0)
{
Alert.Show("请选择需要确认的账单!");
return;
}
StringBuilder sb = new StringBuilder();
int outTotal = 0;
int backTotal = 0;
foreach (int rowIndex in seelctedRows)
{
long id = (long)previewGrid.DataKeys[rowIndex][0];
BillType billType = (BillType)previewGrid.DataKeys[rowIndex][1];
switch (billType)
{
case BillType.OutBill:
//出货单
if (ProcessOutBill(id, userId))
{
outTotal++;
}
break;
case BillType.BackBill:
//退货单
if (ProcessBackBill(id, userId))
{
backTotal++;
}
break;
}
}
if (backTotal > 0)
{
Alert.Show(string.Format("汇整完成, 出货单:{0}条，退货单:{1}条。", outTotal, backTotal));
}
else
{
Alert.Show(string.Format("汇整完成, 出货单:{0}条。", outTotal));
}
previewWindow.Hidden = true;
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
JArray jarr = Grid2.GetMergedData();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string result = "";
int n = 0;
for (int i = 0; i < jarr.Count; i++)
{
try
{
var model2 = new Adjust01();
//string str = jarr[i]["status"].ToString();
if (jarr[i]["status"].ToString().Equals("modified"))
{
model2.SetIsNew(false);
}
else if (jarr[i]["status"].ToString().Equals("unchanged"))
{
continue;
}
else
{
model2.SetIsNew(true);
}
model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString();
if (!String.IsNullOrEmpty(jarr[i]["values"]["AD_ID01"].ToString()))
{
model2.AD_ID = jarr[i]["values"]["AD_ID01"].ToString();
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString());
model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString();
model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString());
model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString());
model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString());
model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
Adjust01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
return(result);
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
// int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtPwd.Text.Trim()))
{
return(txtPwd.Label + "不能为空！");
}
if (string.IsNullOrEmpty(txtPwd1.Text.Trim()))
{
return(txtPwd1.Label + "不能为空！");
}
if (txtPwd.Text.Trim() != txtPwd1.Text.Trim())
{
return(txtPwd.Label + "两次输入密码不一致！");
}
#endregion
#region 赋值
int managerId = OnlineUsersBll.GetInstence().GetManagerId();
var model = Manager.SingleOrDefault(x => x.Id == managerId);
model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtPwd.Text.Trim()));
#endregion
//----------------------------------------------------------
//存储到数据库
ManagerBll.GetInstence().Save(this, model);
Alert.Show("修改成功!");
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
/// <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>
/// OrderDep00保存
/// </summary>
/// <returns></returns>
public string OrderDep00Save(JArray upJson)
{
string result = "";
for (int i = 0; i < upJson.Count; i++)
{
try
{
int _Id = ConvertHelper.Cint(upJson[i]["values"]["Id"].ToString());
var model = new ORDER_DEP00(x => x.Id == _Id);
if (upJson[i]["status"].ToString() == "newadded")
{
model.ORDDEP_ID = TABLE_SEEDBll.GetInstence().GetTableSeed("ORDER_DEP00", "", 0);
}
else
{
model.ORDDEP_ID = upJson[i]["values"]["ORDDEP_ID"].ToString();
}
model.ORDDEP_NAME = upJson[i]["values"]["ORDDEP_NAME"].ToString();
model.ORDER_WEEK = upJson[i]["values"]["ORDER_WEEK"].ToString();
//string a = upJson[i]["values"]["USABLE"].ToString();
if (upJson[i]["values"]["USABLE"].ToString() == "True")
{
model.USABLE = 1;
}
else
{
model.USABLE = 0;
}
model.CRT_USER_ID = upJson[i]["values"]["CRT_USER_ID"].ToString();
model.CRT_DATETIME = DateTime.Now;
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.MOD_DATETIME = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
ORDER_DEP00Bll.GetInstence().Save(this, model);
}
catch (Exception err)
{
result = result + upJson[i]["values"]["ORDDEP_NAME"].ToString() + "相关数据保存失败" + Environment.NewLine;
}
}
if (String.IsNullOrEmpty(result))
{
result = "";
}
//int i = aa.Count;
return(result);
}
/// <summary>
/// 作废按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void BtnPur00_Cancel(Object sender, EventArgs e)
{
string Pur00_ID = tbxPurchase_ID.Text.ToString();
var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == Pur00_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();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.MOD_DATETIME = DateTime.Now;
model.LAST_UPDATE = DateTime.Now;
model.MOD_USER_ID = OlUser.Manager_LoginName;
string result = "";
try
{
Purchase00Bll.GetInstence().Save(this, model);
}
catch (Exception err)
{
result = err.Message;
}
//BtnPur01_Edit(sender, e);
//string result = Pur01_Edit();
if (String.IsNullOrEmpty(result))
{
result = Pur_Edit();
}
LoadPur();
LoadDataPur01();
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error);
//FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information);
}
/// <summary>
/// 核准
/// </summary>
public override void Approval()
{
GridRow row = resultGrid.SelectedRow;
if (row == null)
{
Alert.Show("请选择需要核准的应付账单");
return;
}
try
{
int Id = Convert.ToInt32(row.DataKeys[0].ToString());
DUE00 due00 = selectHelper.SelectSingle <DUE00>(false, null, new List <ConditionFun.SqlqueryCondition>()
{
new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, Id, false, false)
});
if (due00 != null)
{
if (due00.STATUS != SubsonicConstants.STATUS_NEW)
{
Alert.Show(string.Format("应付账单[{0}]不是存档状态无法核准"));
return;
}
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
int ret = updaterHelper.Update(string.Format("update DUE00 set status = 2 where status = 1 and id = {0}", Id));
if (ret == 1)
{
Alert.Show(string.Format("核准[{0}]成功", row.DataKeys[2].ToString()));
}
else
{
Alert.Show(string.Format("核准[{0}]失败", row.DataKeys[2].ToString()));
}
//加载页面
LoadData();
}
else
{
Alert.Show(string.Format("核准失败，未查询到应付账单[{0}]", row.DataKeys[1].ToString()));
}
}catch (Exception e)
{
CommonBll.WriteLog("核准应付账单发生错误", e);
Alert.Show("核准失败,核准发生异常，详情请见日志");
}
}
/// <summary>
/// 核准
/// </summary>
public override void Approval()
{
GridRow row = resultGrid.SelectedRow;
if (row == null)
{
Alert.Show("请选择需要核准的应付账单");
return;
}
try
{
int id = Convert.ToInt32(row.DataKeys[0].ToString());
RECEIVABLES00 pay = selectHelper.SelectSingle <RECEIVABLES00>(false, null, new List <ConditionFun.SqlqueryCondition>()
{
new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, id, false, false)
});
if (SubsonicConstants.STATUS_NEW == pay.STATUS)
{
Alert.Show("应付账单状态不是存档状态，不能核准");
return;
}
else
{
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
int ret = updaterHelper.Update(string.Format("update RECEIVABLES00 set status = 2 where status = 1 and id = {0}", id));
//核准时间
pay.MOD_DATETIME = DateTime.Now;
//核准人
pay.MOD_USER_ID = OlUser.Manager_LoginName;
pay.Save();
if (ret == 1)
{
Alert.Show(string.Format("出货单号[{0}]核准成功", pay.OUT_ID));
}
else
{
Alert.Show(string.Format("出货单号[{0}]核准失败", pay.OUT_ID));
}
LoadData();
}
}catch (Exception e)
{
CommonBll.WriteLog(string.Format("id:{0}核准失败", row.DataKeys[0]), e);
}
}
/// <summary>
/// Grid点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_RowCommand(object sender, FineUI.GridCommandEventArgs e)
{
GridRow gr = Grid1.Rows[e.RowIndex];
//获取当前点击列的主键ID
object id = gr.DataKeys[0];
//因为要记录修改人，修改时间跟最后更新时间，所以将单字段更新换成多字段更新
switch (e.CommandName)
{
case "ENABLE":
try
{
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey());
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("ENABLE", ConvertHelper.StringToByte(e.CommandArgument));
dic.Add("MOD_DATETIME", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")));
dic.Add("MOD_USER_ID", OlUser.Manager_LoginName);
dic.Add("LAST_UPDATE", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")));
if (ConvertHelper.Cint0(id) > 0)
{
PROD_DEPBll.GetInstence().UpdateValue(this, ConvertHelper.Cint0(id), dic);
}
LoadData();
//PROD_KINDBll.GetInstence().Save(this, model);
}
catch (Exception err)
{
//出现异常，保存出错日志信息
CommonBll.WriteLog("保存失败", err);
}
//更新状态
//PROD_KINDBll.GetInstence().UpdateENABLE(this, ConvertHelper.Cint0(id), ConvertHelper.Cint0(e.CommandArgument));
//重新加载
//LoadData();
break;
case "ButtonEdit":
//打开编辑窗口
Window1.IFrameUrl = "ProdDepEdit.aspx?Id=" + id + "&" + MenuInfoBll.GetInstence().PageUrlEncryptStringNoKey(id + "");
Window1.Hidden = false;
break;
}
}
/// <summary>
/// 入库核准
/// </summary>
public override void Approval()
{
string ma_id = GridViewHelper.GetSelectedKey(Grid1, true);
string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
int result = Material00Bll.GetInstence().ApprovalReduceStock(SHOP_ID, ma_id, manager_LoginName);
if (result == 0)
{
Alert.Show("核准成功！");
}
else
{
Alert.Show("核准失败！请重新汇整");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//获取ID值
hidId.Text = RequestHelper.GetQueryString("ORDER_Id") + "";
//部门
int Branch_Id = ConvertHelper.Cint0(OnlineUsersBll.GetInstence().GetUserOnlineInfo("Branch_Id").ToString());
//绑定下拉列表
PRODUCT00Bll.GetInstence().BandDropDownListShowProductName1(this, ddlPROD_NAME1);
//加载数据
LoadData();
}
}
/// <summary>
/// 加载数据
/// </summary>
public override void LoadData()
{
//获取登录用户
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//获取用户所属shop
shopId = OlUser.SHOP_ID;
//出货单号
string outNo = outId.Text;
//状态
int status = 0;
if (billStatus.SelectedIndex > 0)
{
status = Convert.ToInt32(billStatus.SelectedValue);
}
List <ConditionFun.SqlqueryCondition> conditionList = new List <ConditionFun.SqlqueryCondition>();
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.GreaterThan, 0, false, false));
string selectedValue = shopIdDropdown.SelectedValue;
//添加门店过滤
if (selectedValue != null && !selectedValue.Equals(shopId))
{
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "IN_SHOP", Comparison.Equals, selectedValue, false, false));
}
//出货单号过滤
if (outNo != null && outNo.Trim().Length > 0)
{
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "OUT_ID", Comparison.Like, outNo + "%", false, false));
}
//添加状态过滤
if (status > 0)
{
conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "STATUS", Comparison.Equals, status, false, false));
}
RECEIVABLES00Bll.GetInstence().BindGrid(resultGrid, 0, 30, conditionList);
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
//检测用户是否超时退出
OnlineUsersBll.GetInstence().IsTimeOut();
if (!IsPostBack)
{
//检测当前页面是否有访问权限
//MenuInfoBll.GetInstence().CheckPagePower(this);
#region 设置页面按键权限
try
{
//定义按键控件
Control btnControl = null;
//找到页面放置按键控件的位置
ControlCollection controls = MenuInfoBll.GetInstence().GetControls(this.Controls, "toolBar");
//逐个读取出来
if (controls != null)
{
for (int i = 0; i < controls.Count; i++)
{
//取出控件
btnControl = controls[i];
//判断是否除了刷新、查询和关闭以外的按键 btnControl.ID != "ButtonAdd" && btnControl.ID != "ButtonEdit" && btnControl.ID != "ButtonDelete" && && btnControl.ID != "ButtonReset"
if (btnControl.ID != "ButtonRefresh" && btnControl.ID != "ButtonSearch" && btnControl.ID != "ButtonClose" && btnControl.ID != "ButtonCancel")
{
//是的话检查该按键当前用户是否有控件权限，没有的话则禁用该按键
((FineUI.Button)btnControl).Enabled = MenuInfoBll.GetInstence().CheckControlPower(this, btnControl.ID);
}
}
}
}
catch (Exception) { }
#endregion
//记录用户当前所在的页面位置
CommonBll.UserRecord(this);
}
//运行UI页面初始化函数，子类继承后需要重写本函数，以提供给本初始化函数调用
Init();
}
/// <summary>
/// 订货部门新增一行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonOrderDepNewRow_Clikc(object sender, EventArgs e)
{
JObject deObject = new JObject();
deObject.Add("Id", "0");
deObject.Add("ORDDEP_ID", "");
deObject.Add("ORDDEP_NAME", "");
deObject.Add("ORDER_WEEK", "");
deObject.Add("USABLE", true);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string lgname = OlUser.Manager_LoginName;
deObject.Add("CRT_USER_ID", lgname);
deObject.Add("CRT_DATETIME", DateTime.Now.ToString());
deObject.Add("MOD_USER_ID", OlUser.Manager_LoginName);
deObject.Add("MOD_DATETIME", DateTime.Now.ToString());
Grid1.AddNewRecord(deObject, true);
}
protected void ddlORDER_DEP_SelectedIndexChanged(object sender, EventArgs e)
{
JArray mergedData = Grid1.GetMergedData();
int gridrowsCount = mergedData.Count;
if (gridrowsCount > 0)
{
Window1.Hidden = false;
}
string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
string ORDER_DEP_VALUE = ddlORDER_DEP.SelectedValue;
if (SHOP_ID != "0")
{
PRODUCT00Bll.GetInstence().BandDropDownListShowProductName_1(this, DropDownList1, SHOP_ID); // (System.Web.UI.WebControls.DropDownList)
}
}
/// <summary>读取数据</summary>
public override void LoadData()
{
#region 展示用户信息
//在线人数
txtOnlineUserCount.Text = OnlineUsersBll.GetInstence().GetUserOnlineCount() + "";
//当前用户信息
var userHashKey = OnlineUsersBll.GetInstence().GetUserHashKey();
var model = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == userHashKey);
if (model == null)
{
return;
}
//用户名称
txtUser.Text = model.Manager_CName;// +" [" + IpHelper.GetUserIp() + "]";
//部门
txtSHOPName.Text = model.SHOP_NAME1;
//职位
txtPositionInfoName.Text = model.Position_Name;
#endregion
#region 菜单栏数据绑定
//获取用户页面操作权限
_pagePower = OnlineUsersBll.GetInstence().GetPagePower();
//创建查询条件
var wheres = new List <ConditionFun.SqlqueryCondition>();
//条件：只查询出需要显示的菜单
wheres.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, MenuInfoTable.IsDisplay, Comparison.Equals, 1));
//进行查询，获取DataTable
var dt = MenuInfoBll.GetInstence().GetDataTable(false, 0, null, 0, 0, wheres);
//绑定树列表
BandingTree(dt);
#endregion
#region 开启时钟检测
Timer1.Enabled = true;
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
//获取ID值
hidId.Text = RequestHelper.GetInt0("Id") + "";
// SHOP_hidId.Text = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
HiddenLastShop_Id.Text = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false);
if (user.Contains("区域管理员"))
{
ddlShop.Enabled = true;
}
else
{
ddlShop.Enabled = false;
}
//加载数据
LoadData();
// 删除选中单元格的客户端脚本
string deleteScript = GetDeleteScript(Grid1);
// 删除选中行按钮
btnDelete.OnClientClick = Grid1.GetNoSelectionAlertReference("请至少选择一项！") + deleteScript;
//deleteScript;
//按钮
//ButtonApproval.Enabled = false;
//ButtonSave.Enabled = false;
}
catch (Exception e1)
{
MessageBox.Show(this, e1.Message);
}
// LoadData();
}
}
///// <summary>
///// 更换分店事件
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
//protected void shopIdDropdown_SelectedIndexChanged(object sender, EventArgs e)
//{
// LoadData();
//}
/// <summary>
/// 汇整出货单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Archive_Click(object sender, EventArgs e)
{
archiveWindow.Hidden = true;
//获取登录用户
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//登录名
string userId = OlUser.Manager_LoginName;
//获取用户所属shop
shopId = OlUser.SHOP_ID;
DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker;
DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker;
List <ReceiveBillMain> previewList = new List <ReceiveBillMain>();
//出货单
List <ReceiveBillMain> tmpList = QueryOutBill(dpStart.Text, dpEnd.Text, userId);
if (tmpList.Count > 0)
{
previewList.AddRange(tmpList);
}
//退货单
tmpList = QueryBackBill(dpStart.Text, dpEnd.Text, userId);
if (tmpList.Count > 0)
{
previewList.AddRange(tmpList);
}
//Alert.Show(string.Format("汇整完成，共汇整{0}条出货单.", total));
previewWindow.Hidden = false;
previewWindow.Top = 100;
Grid previewGrid = previewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid;
previewGrid.DataSource = previewList;
previewGrid.DataBind();
}
protected void Grid2AddNewRow_Click(object sender, EventArgs e)
{
FineUI.Grid Grid3 = Window2.FindControl("PanelA").FindControl("Grid3") as FineUI.Grid;
int[] selections = Grid3.SelectedRowIndexArray;
string _ORDDEP_ID = hidORDDEP_ID.Text.ToString();
string result = "";
if (!String.IsNullOrEmpty(_ORDDEP_ID))
{
foreach (int i in selections)
{
int _Id = ConvertHelper.Cint(Grid3.DataKeys[i][0].ToString());
var model = new PROD_DEP(x => x.Id == _Id);
string checkResult = CheckDataAddDep(model.DEP_ID);
if (!String.IsNullOrEmpty(checkResult))
{
result = result + checkResult + Environment.NewLine;
continue;
}
JObject deObject = new JObject();
deObject.Add("Id1", "0");
deObject.Add("ORDDEP_ID1", _ORDDEP_ID);
deObject.Add("DEP_ID1", model.DEP_ID);
deObject.Add("DEP_NAME1", model.DEP_NAME);
deObject.Add("Meno", " ");
deObject.Add("USABLE1", true);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
string lgname = OlUser.Manager_LoginName;
deObject.Add("CRT_USER_ID1", lgname);
deObject.Add("CRT_DATETIME1", DateTime.Now.ToString());
deObject.Add("MOD_USER_ID1", OlUser.Manager_LoginName);
deObject.Add("MOD_DATETIME1", DateTime.Now.ToString());
Grid2.AddNewRecord(deObject, true);
}
}
if (!String.IsNullOrEmpty(result.Trim()))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Information);
}
}
public override void Init()
{
//获取登录用户
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//获取用户所属shop
shopId = OlUser.SHOP_ID;
//绑定门店下拉列表
//SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, shopIdDropdown);
//查询查询所有分店
var shop = SHOP00Bll.GetInstence().GetModelForCache(s => s.SHOP_ID.Equals(shopId));
List <ConditionFun.SqlqueryCondition> shopCondition = new List <ConditionFun.SqlqueryCondition>();
shopCondition.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_Area_ID", Comparison.Equals, shop.SHOP_Area_ID, false, false));
List <SHOP00> shopList = selectHelper.Select <SHOP00>(false, 0, null, shopCondition, null).ExecuteTypedList <SHOP00>();
shopIdDropdown.DataSource = shopList;
shopIdDropdown.DataTextField = "SHOP_NAME1";
shopIdDropdown.DataValueField = "SHOP_ID";
shopIdDropdown.DataBind();
foreach (SHOP00 shop00 in shopList)
{
shopDic[shop00.SHOP_ID] = shop00.SHOP_NAME1;
}
//初始化时间
DatePicker outStartDate = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker;
outStartDate.SelectedDate = ConvertHelper.StringToDatetime(DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd 00:00:00"));
DatePicker outEndDate = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker;
outEndDate.SelectedDate = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
}
public override void Approval()
{
string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名
txtAPP_USER.Text = manager_LoginName;
txtAPP_DATE.SelectedDate = DateTime.Now;
ddlStatus.SelectedValue = "2";
string ORDER_ID = txtORDER_ID.Text.Trim();
var model = new ORDER00(x => x.ORDER_ID == ORDER_ID);
model.APP_USER = txtAPP_USER.Text;
model.APP_DATE = ConvertHelper.StringToDatetime(txtAPP_DATE.SelectedDate.ToString());
model.STATUS = 2;
ORDER00Bll.GetInstence().Save(this, model);
ButtonPowers();
}
protected void Grid1_PreDataBound(object sender, EventArgs e)
{
// 设置LinkButtonField的点击客户端事件
// LinkButtonField deleteField = Grid1.FindColumn("Delete") as LinkButtonField;
// deleteField.OnClientClick = GetDeleteScript(Grid1);
string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();
// string ORDER_DEP_VALUE = ddlORDER_DEP.SelectedValue;
if (SHOP_ID != "0")
{
PRODUCT00Bll.GetInstence().BandDropDownListShowProductName_1(this, DropDownList1, SHOP_ID); // (System.Web.UI.WebControls.DropDownList)
}
//DropDownList1.DataTextField = PRODUCT00Table.PROD_NAME1;
//DropDownList1.DataValueField = PRODUCT00Table.PROD_ID;
// DropDownList1.SelectedValue = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][PRODUCT00Table.PROD_ID].ToString();
}
protected void ButtonApproval_Click(object sender, EventArgs e)
{
string str = GridViewHelper.GetSelectedKey(Grid1, true);
string[] col_id_shop_id = str.Split(',');
string shop_id = col_id_shop_id[1];
string col_id = col_id_shop_id[0];
string user_id = OnlineUsersBll.GetInstence().GetManagerId().ToString();
int ex_int = OUT00Bll.GetInstence().SplitOrders(col_id, user_id);
if (ex_int == 1)
{
Alert.Show("核准失败，请重新核准！");
}
else
{
Alert.Show("核准成功！");
}
}
public void btnSaveCONTRACT01()
{
JArray conJons = Grid2.GetMergedData();
for (int i = 0; i < conJons.Count; i++)
{
CONTRACT01 model = null;
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
if (conJons[i]["values"]["Id01"].ToString() == "0" || conJons[i]["status"].ToString() == "newadded")
{
model = new CONTRACT01();
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
int _id = ConvertHelper.Cint(conJons[i]["values"]["Id01"].ToString());
model = new CONTRACT01(x => x.Id == _id);
}
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
model.CONTRACT_ID = conJons[i]["values"]["CONTRACT_ID01"].ToString();
model.PROD_ID = conJons[i]["values"]["PROD_ID01"].ToString();
model.CONTRACT_PRICE = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE01"].ToString());
model.CONTRACT_PRICE1 = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE101"].ToString());
model.CONTRACT_PRICE2 = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE201"].ToString());
string a = conJons[i]["values"]["USABLE01"].ToString();
if (conJons[i]["values"]["USABLE01"].ToString() == "True")
{
model.USABLE = 1;
}
else
{
model.USABLE = 0;
}
model.Meno = conJons[i]["values"]["Meno01"].ToString();
CONTRACT01Bll.GetInstence().Save(this, model);
}
}
/// <summary>
/// 核准
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void Approval()
{
string str = GridViewHelper.GetSelectedKey(Grid1, true);
string[] col_id_shop_id = str.Split(',');
string col_id = col_id_shop_id[0];
string shop_id = col_id_shop_id[1];
int ispp = ConvertHelper.Cint0(PPhidId.Text.Trim());
string user_id = OnlineUsersBll.GetInstence().GetManagerId().ToString();
int result = Col_Order00Bll.GetInstence().ADD_PLAN_PURCHASE(col_id, shop_id, user_id, ispp);
if (result == 0)
{
Alert.Show("核准成功！");
}
else
{
Alert.Show("核准失败！请重新汇整");
}
}
