public string ShowPermissionsStr(string uPerStr)
{
string reStr = "";
if (uPerStr.Trim() != "")
{
if (uPerStr.Trim() == "X")
{
reStr = "超级管理员";
}
else
{
DataTable UserPopedomList = new DataTable();
try
{
UserPopedomList = UsersUtils.GetUserPopedom();
foreach (DataRow dr in UserPopedomList.Rows)
{
if (CheckUserPopedoms(dr["PopedomID"].ToString(), uPerStr))
{
reStr += " " + dr["PopedomName"].ToString();
}
}
}
finally
{
UserPopedomList.Clear();
}
}
}
return(reStr);
}
/// <summary>
/// 验证用户信息
/// </summary>
public bool CheckUser()
{
userid = Utils.StrToInt(Utils.GetCookie(config.CookieTag, "userid"), -1);
password = UsersUtils.GetCookiePassword(config.Passwordkey);
if (userid > 0)
{
userid = tbUserInfo.CheckPassword(userid, password, false);
UserCode = Utils.UrlEncode(DES.Encode(this.userid + "$|$" + password, config.Passwordkey));
}
else
{
if (HTTPRequest.GetString("UserCode").Trim() != "")
{
string UserCode = DES.Decode(HTTPRequest.GetString("UserCode").Trim(), config.Passwordkey);
if (UserCode.Trim() != "")
{
string[] UserCodeArr = Utils.SplitString(UserCode.Trim(), "$|$");
if (UserCodeArr.Length == 2)
{
userid = Convert.ToInt32(UserCodeArr[0]);
password = UserCodeArr[1].Trim();
if (userid > 0)
{
userid = tbUserInfo.CheckPassword(userid, password, false);
}
}
}
}
}
return(userid > 0);
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
ucode = DES.Encode(this.userinfo.uName + "|" + UsersUtils.GetCookiePassword(config.Passwordkey), config.Passwordkey);
CertificateID = HTTPRequest.GetInt("CertificateID", 0);
Act = HTTPRequest.GetString("Act");
w = HTTPRequest.GetInt("w", 640);
h = HTTPRequest.GetInt("h", 480);
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
string referer = HTTPRequest.GetQueryString("reurl");
if (!HTTPRequest.IsPost() || referer != "")
{
string r = "";
if (referer != "")
{
r = referer;
}
else
{
if ((HTTPRequest.GetUrlReferrer() == "") || (HTTPRequest.GetUrlReferrer().IndexOf("login") > -1) ||
HTTPRequest.GetUrlReferrer().IndexOf("logout") > -1)
{
r = "Default.aspx";
}
else
{
r = HTTPRequest.GetUrlReferrer();
}
}
Utils.WriteCookie("reurl", (referer == "" || referer.IndexOf("login.aspx") > -1) ? r : referer);
}
SetUrl(Utils.UrlDecode(UsersUtils.GetReUrl()));
SetMetaRefresh();
SetShowBackLink(false);
tbUserInfo.UpdateUserOnlineTime(userid, DateTime.Now.ToString());
OnlineUsers.DeleteRows(olid);
UsersUtils.ClearUserCookie();
this.userid = 0;
AddMsgLine("已经清除了您的登录信息");
}
/// <summary>
/// 验证用户指定权限
/// </summary>
public bool CheckUserPopedoms(string PopedomsID)
{
bool re = false;
if (this.userpopedom != "")
{
string tp = "," + this.userpopedom + ",";
if (tp.IndexOf("," + PopedomsID + ",") > -1)
{
re = true;
}
else
{
//是否上级权限
string[] uparray = Utils.SplitString(tp, ",");
string _p = UsersUtils.GetUserPopedomByPopedomIDUp(PopedomsID);
if (_p.Trim() != "")
{
_p = ',' + _p.Trim();
}
foreach (string up in uparray)
{
if (_p.IndexOf("," + up + ",") > -1)
{
re = true;
break;
}
}
}
}
else
{
re = false;
}
return(re);
}
public string Order_QRCode_URL = ""; //外部查看连接
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
ordertype = HTTPRequest.GetInt("ordertype", 0);
orderid = HTTPRequest.GetInt("orderid", 0);
Act = Utils.ChkSQL(HTTPRequest.GetString("Act")).Trim();
format = HTTPRequest.GetString("format");
IsFirst = (HTTPRequest.GetString("IsFirst").Trim() != "") ? Convert.ToBoolean(HTTPRequest.GetString("IsFirst").Trim()) : false;;
if (ordertype > 0 && Act != "")
{
#region 权限判断
switch (ordertype)
{
case 1: //采购入库=1
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-1-1") || CheckUserPopedoms("3-3-4-1-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-1-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-1-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 采购入库单 列表!");
}
break;
case 2: //采购退货=2
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-2-1") || CheckUserPopedoms("3-3-4-2-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-2-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-2-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 采购退货单 列表!");
}
break;
case 3: //销售发货=3
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-3-1") || CheckUserPopedoms("3-3-4-3-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-3-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-3-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 销售发货单 列表!");
}
break;
case 4: //销售退货=4
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-4-1") || CheckUserPopedoms("3-3-4-4-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-4-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-4-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 销售退货单 列表!");
}
break;
case 5: //赠品=5
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-5-1") || CheckUserPopedoms("3-3-4-5-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-5-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-5-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 赠品单 列表!");
}
break;
case 6: //样品=6
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-6-1") || CheckUserPopedoms("3-3-4-6-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-6-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-6-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 样品单 列表!");
}
break;
case 7: //代购=7
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-7-1") || CheckUserPopedoms("3-3-4-7-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-7-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-7-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 代购单 列表!");
}
break;
case 8: //库存调整=8
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1") || CheckUserPopedoms("3-3-4-8-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 库存调整单 列表!");
}
break;
case 9: //库存调拨=9
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1") || CheckUserPopedoms("3-3-4-8-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 库存调拨单 列表!");
}
break;
case 10: //坏货=10
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1") || CheckUserPopedoms("3-3-4-8-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 坏货单 列表!");
}
break;
case 11: //换货=11
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1") || CheckUserPopedoms("3-3-4-8-2"))
{
switch (Act)
{
case "8":
case "v":
if (ispost)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-2"))
{
oi = Orders.GetOrderInfoModel(this.orderid);
if (oi != null)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
else
{
AddErrLine("无法 添加 记录，单据状态限制!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足,无法 操作 列表!");
}
}
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-3-4-8-1"))
{
OrderWorkingType = 8;
}
else
{
AddErrLine("权限不足,无法 查看 列表!");
}
break;
}
}
else
{
AddErrLine("权限不足,无法浏览 换货单 列表!");
}
break;
case 12: //修正数据
if (CheckUserPopedoms("X") || CheckUserPopedoms("7-2-1-5-7-1"))
{
IsEditData = true;
}
else
{
AddErrLine("权限不足,无法进行数据调整操作!");
}
break;
}
#endregion
}
else
{
AddErrLine("参数错误,请返回!");
}
if (!IsErr())
{
oOrderDateTime = (HTTPRequest.GetString("oOrderDateTime").Trim() != "") ? Convert.ToDateTime(Utils.ChkSQL(HTTPRequest.GetString("oOrderDateTime"))) : DateTime.Now;
string _OrderListDataJson = HTTPRequest.GetString("OrderListDataJson");
OrderWorkingLogMsg = Utils.ChkSQL(HTTPRequest.GetString("OrderWorkingLogMsg"));
string _splRemake = Utils.ChkSQL(HTTPRequest.GetString("splRemake"));
// oi = new OrderInfo();
switch (Act)
{
#region 查看,修改
case "v":
case "e":
oi = Orders.GetOrderInfoModel(orderid);
if (!ispost)
{
if (oi != null)
{
//CertificateList = Certificates.GetCertificateInfoList(" cObject=1 and cObjectID=" + oi.OrderID + " and cState=0 order by cDateTime desc").Tables[0];
PrepayMoney = Certificates.GetPrepayMoneyByOrderID(oi.OrderID);
oOrderDateTime = oi.oOrderDateTime;
//是否为网购订单
_ms = M_Utils.GetM_SendGoodsInfoModelByOrderID(oi.OrderID);
if (_ms != null)
{
IsMOrder = true;
}
//未审核,可修改
if (oi.oSteps == 1)
{
this.ShowEdit = true;
ShowTree = true;
IsVerify = true;
}
else
{
if (oi.oType != 11) //非换货单可修改
{
if (oi.oPrepay == 1)
{
//是否已完成预付操作
IsPrepayOK = Certificates.CheckCertificateByOrderID(oi.OrderID);
}
else
{
IsPrepayOK = true;
}
//已审核已发货
if (oi.oSteps == 3)
{
this.ShowEdit = true;
}
else if (oi.oSteps >= 4)
{
//已经收货,已验收,已对账
IsNOFull = Orders.CheckOrderIsFull(oi.OrderID);
}
}
else
{
IsPrepayOK = true;
this.ShowEdit = false;
}
}
OrderListDataJsonStr = ""; //{"OrderListJson":[{"OrderListID":0,"OrderID":0,"StorageID":0,"ProductsID":0,"oQuantity":0,"oPrice":0,"oMoney":0,"StoresSupplierID":0,"IsPromotions":0,"oWorkType":0,"oAppendTime":"\/Date(1289206775426+0800)\/","OrderFieldValueInfo":[{"OrderFieldValueID":0,"OrderFieldID":0,"OrderListID":0,"oFieldValue":null,"IsVerify":0,"oAppendTime":"\/Date(1289206775426+0800)\/"}]}]}
string OrderFieldValueStr = "";
string tSteps = "";
string tSteps_b = "";
Order_QRCode_URL = "" + config.Sysurl + "/o-" + oi.OrderID + ".aspx?rc=" + Utils.UrlEncode(DES.Encode(oi.LastPrintDateTime.ToString() + "|" + oi.oOrderNum, config.Passwordkey)).Trim();
if (IsFirst) //输出原始单据
{
tSteps = " oWorkType=0";
tSteps_b = " IsVerify=0";
}
else
{
tSteps = ((oi.oSteps == 1) ? " oWorkType=0" : " oWorkType<>0").ToString();
tSteps_b = ((oi.oSteps == 1) ? " IsVerify=0" : " IsVerify<>0").ToString();
}
//取已收发列表
DataTable Storage_Order = tbStorageProductLogInfo.GetStorageProductLogListINOrderList(oi.OrderID).Tables[0];
if (Storage_Order != null)
{
foreach (DataRow dr_Storage_Order in Storage_Order.Rows)
{
StorageOrderList += "{\"OrderListID\":" + dr_Storage_Order["OrderListID"].ToString() + "," +
"\"StorageID\":" + dr_Storage_Order["StorageID"].ToString() + "," +
"\"ProductsID\":" + dr_Storage_Order["ProductsID"].ToString() + "," +
"\"pQuantity\":" + dr_Storage_Order["pQuantity"].ToString() + "},";
}
if (StorageOrderList != "")
{
StorageOrderListJsonStr = "{\"StorageOrderList\":[" + Utils.ReSQLSetTxt(StorageOrderList) + "]}";
}
}
//取单据列表
DataTable OrderListData = Orders.GetOrderListInfoList(" OrderID=" + oi.OrderID + " and " + tSteps + " order by OrderListID asc").Tables[0];
if (OrderListData != null)
{
foreach (DataRow dr_OrderListData in OrderListData.Rows)
{
OrderFieldValueStr = "";
DataTable OrderFieldValueData = Orders.GetOrderFieldValueInfoList(" OrderListID=" + dr_OrderListData["OrderListID"].ToString() + "and " + tSteps_b).Tables[0];
foreach (DataRow dr_OrderFieldValueData in OrderFieldValueData.Rows)
{
OrderFieldValueStr += "{\"OrderFieldValueID\":" + dr_OrderFieldValueData["OrderFieldValueID"].ToString() + ",\"OrderFieldID\":" + dr_OrderFieldValueData["OrderFieldID"].ToString() + ",\"OrderListID\":" + dr_OrderFieldValueData["OrderListID"].ToString() + ",\"oFieldValue\":\"" + dr_OrderFieldValueData["oFieldValue"].ToString() + "\",\"IsVerify\":" + dr_OrderFieldValueData["IsVerify"].ToString() + ",\"oAppendTime\":\"" + dr_OrderFieldValueData["oAppendTime"].ToString() + "\"},";
}
if (OrderFieldValueStr != "")
{
OrderFieldValueStr = ",\"OrderFieldValueInfo\":[" + Utils.ReSQLSetTxt(OrderFieldValueStr) + "]";
}
OrderListDataJsonStr += "{\"OrderListID\":" + dr_OrderListData["OrderListID"].ToString() + "," +
"\"OrderID\":" + dr_OrderListData["OrderID"].ToString() + "," +
"\"StorageID\":" + dr_OrderListData["StorageID"].ToString() + "," +
"\"StorageName\":\"" + dr_OrderListData["StorageName"].ToString() + "\"," +
"\"ProductsID\":" + dr_OrderListData["ProductsID"].ToString() + "," +
"\"ProductsName\":\"" + Utils.ReplaceString(Utils.ReplaceString(dr_OrderListData["ProductsName"].ToString(), "'", "\\'", false), "\"", "\\\"", false) + "\"," +
"\"oQuantity\":" + dr_OrderListData["oQuantity"].ToString() + "," +
"\"oPrice\":" + dr_OrderListData["oPrice"].ToString() + "," +
"\"oMoney\":" + dr_OrderListData["oMoney"].ToString() + "," +
"\"StoresSupplierID\":" + dr_OrderListData["StoresSupplierID"].ToString() + "," +
"\"IsPromotions\":" + dr_OrderListData["IsPromotions"].ToString() + "," +
"\"oWorkType\":" + dr_OrderListData["oWorkType"].ToString() + "," +
"\"IsGifts\":" + dr_OrderListData["IsGifts"].ToString() + "," +
"\"oAppendTime\":\"" + dr_OrderListData["oAppendTime"].ToString() + "\"," +
"\"PriceClassID\":\"" + dr_OrderListData["PriceClassID"].ToString() + "\" " + OrderFieldValueStr + "},";
}
if (OrderListDataJsonStr.Trim() != "")
{
OrderListDataJsonStr = "{\"OrderListJson\":[" + Utils.ReSQLSetTxt(OrderListDataJsonStr) + "]}";
}
}
}
else
{
AddErrLine("参数错误,单据列表不存在!");
}
}
break;
#endregion
}
if (ispost)
{
if (!IsEditData)
{
//非作废单据
if (oi.oState != 1)
{
if (oi.oSteps == 2 || oi.oSteps == 3)
{
}
}
else
{
AddErrLine("此单已作废,无法修改!");
AddScript("window.setTimeout('history.back(1);',2000);");
}
}
else
{
oi = new OrderInfo();
}
if (!IsErr())
{
//增加发货记录
spl.StorageID = 0; //暂留无用
spl.StaffID = this.userid;
spl.OrderID = oi.OrderID;
spl.splRemake = _splRemake;
spl.splAppendTime = DateTime.Now;
//Response.Write (_OrderListDataJson);
// Response.End ();
spl.StorageOrderListDataJson = (StorageOrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(StorageOrderListDataJson));
int StorageProductLogDataID = tbStorageProductLogInfo.AddStorageProductLogInfo(spl);
if (StorageProductLogDataID > 0)
{
AddMsgLine("保存成功!");
//更新当前在途库存情况
if (oi.oSteps == 2)
{
oi.oSteps = 3;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(orderid);
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 3;
owl.oMsg = OrderWorkingLogMsg;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
try
{
#region 发送邮件给收货人员
//oi = Orders.GetOrderInfoModel(OrderID);
switch (oi.oType)
{
case 1: //采购入库
UsersUtils.SendUserMailByPopedom("3-1-1-4", "采购入库单 等待收货处理,单号:" + oi.oOrderNum, "采购入库单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 2: //采购退货
UsersUtils.SendUserMailByPopedom("3-1-2-4", "采购退货单 等待收货处理,单号:" + oi.oOrderNum, "采购退货单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 3: //销售发货
UsersUtils.SendUserMailByPopedom("3-2-1-4", "销售发货单 等待收货处理,单号:" + oi.oOrderNum, "销售发货单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 4: //销售退货
UsersUtils.SendUserMailByPopedom("3-2-2-4", "销售退货单 等待收货处理,单号:" + oi.oOrderNum, "销售退货单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 5: //赠品
UsersUtils.SendUserMailByPopedom("3-2-3-4", "赠品单 等待收货处理,单号:" + oi.oOrderNum, "赠品单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 6: //样品
UsersUtils.SendUserMailByPopedom("3-2-4-4", "样品单 等待收货处理,单号:" + oi.oOrderNum, "样品单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 7: //代购
UsersUtils.SendUserMailByPopedom("3-2-5-4", "代购单 等待收货处理,单号:" + oi.oOrderNum, "代购单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 11: //换货
UsersUtils.SendUserMailByPopedom("3-2-6-4", "换货单 等待收货处理,单号:" + oi.oOrderNum, "换货单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 10: //坏货
UsersUtils.SendUserMailByPopedom("3-3-3-4", "坏货单 等待收货处理,单号:" + oi.oOrderNum, "坏货单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 8: //库存调整
UsersUtils.SendUserMailByPopedom("3-3-1-4", "库存调整单 等待收货处理,单号:" + oi.oOrderNum, "库存调整单 等待收货处理,单号:" + oi.oOrderNum);
break;
case 9: //库存调拨
UsersUtils.SendUserMailByPopedom("3-3-2-4", "库存调拨单 等待收货处理,单号:" + oi.oOrderNum, "库存调拨单 等待收货处理,单号:" + oi.oOrderNum);
break;
}
#endregion
switch (oi.oType)
{
case 3:
case 4:
case 5:
case 6:
#region 发邮件给业务员
if (oi.StaffID != 0)
{
tbStaffInfo.SendMailToStaff(oi.StaffID, tbStoresInfo.GetStoresInfoModel(oi.StoresSupplierID).sName + "," + GetOrderType(oi.oType.ToString()) + "单:" + oi.oOrderNum + "已发货.", "客户:" + tbStoresInfo.GetStoresInfoModel(oi.StoresSupplierID).sName + ",的" + GetOrderType(oi.oType.ToString()) + "单,单号:" + oi.oOrderNum + "已发货等待收货,请注意跟踪.<br>单据处理情况:" + config.Sysurl + "/o-" + oi.OrderID + ".aspx?rc=" + Utils.UrlEncode(DES.Encode(oi.LastPrintDateTime.ToString() + "|" + oi.oOrderNum, config.Passwordkey)).Trim());
}
#endregion
#region 给客户发邮件
tbStoresInfo.SendMailToStores(oi.StoresSupplierID, GetOrderType(oi.oType.ToString()) + "单 已发货,单号:" + oi.oOrderNum, GetOrderType(oi.oType.ToString()) + "单 已发货,单号:" + oi.oOrderNum);
#endregion
break;
}
}
catch (Exception ex)
{
AddErrLine(ex.Message);
}
}
}
}
}
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
if (format == "json")
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/json";
string Json_Str = "{\"results\": {\"msg\":\"" + this.msgbox_text + "\",\"state\":\"" + (!IsErr()).ToString() + "\"}" + MS_Json + "}";
Response.Write(Json_Str);
Response.End();
}
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
this.documentUtils = new DocumentUtils(db);
this.usersUtils = new UsersUtils(db);
}
public bool ShowProductCostPrice = false; //是否显示成本
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
Act = HTTPRequest.GetString("Act");
//邮件校验码
if (HTTPRequest.GetString("rCode") != "")
{
Session ["r_Code"] = HTTPRequest.GetString("rCode");
}
string _rCode = Session["r_Code"] != null?Convert.ToString(Session["r_Code"]) : ""; //邮件获取
string s_rCode = Session["s_r_Code"] != null?Convert.ToString(Session["s_r_Code"]) : ""; //本地校验
if (_rCode == "" || _rCode != s_rCode)
{
string s_r_Code = s_rCode.Trim() != ""?s_rCode: MakeCode(6); //生成6位验证码
if (Act == "SendCode")
{
Session ["s_r_Code"] = s_r_Code;
UsersUtils.SendMailToEmail(config.ProductCostPriceCodeMail, "商品成本维护校验码", "请在10分钟内输入商品成本维护校验码:<b>" + s_r_Code + "</b>");
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:true,msg:\"OK!\"}");
Response.End();
}
if (Act.Trim() == "UpdatePrice")
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:false,msg:\"No Code!\"}");
Response.End();
}
else
{
ShowRCodeInput(s_r_Code);
} //AddErrLine ("请输入授权码!");
}
else
{
//仓库分类树
StorageClassJson = Caches.GetStorageInfoToJson(-1, false, true);
Aclass = HTTPRequest.GetString("aclass");
if (Aclass.IndexOf("aclass") > -1)
{
string sID = "";
string sCode = "";
string sName = "";
//获得仓库分类编号
StorageClassID = HTTPRequest.GetString("sClassID");
//获得仓库名称、编号、系统编号
StorageName = tbStockProductInfo.getStorageNameByClass(Convert.ToInt32(StorageClassID));
for (int i = 0; i < StorageName.Rows.Count; i++)
{
if (StorageName.Rows [i] ["sState"].ToString() == "0")
{
sName += StorageName.Rows [i] ["sName"].ToString() + "(" + StorageName.Rows [i] ["sCode"].ToString() + ")" + ",";
sID += StorageName.Rows [i] ["StorageID"].ToString() + ",";
sCode += StorageName.Rows [i] ["sCode"].ToString() + ",";
}
}
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{sID:'" + sID + "',sCode:'" + sCode + "',sName:'" + sName + "'}");
Response.End();
}
StorageID = HTTPRequest.GetInt("StorageID", 0);
sDate = HTTPRequest.GetString("sDate").Trim() != "" ? Convert.ToDateTime(HTTPRequest.GetString("sDate").Trim() + " 23:59:59") : DateTime.Now;
//显示列表
if (Act.Trim() != "")
{
className = HTTPRequest.GetString("StorageClassName").Trim();
StorageClassID = HTTPRequest.GetString("StorageClassNum");
if (StorageClassID == "")
{
AddMsgLine("请选择仓库类别后再进行查询!");
}
else
{
priceList = tbProductPriceNOAuto.GetProductPriceNOAutoListNew("").Tables [0];
StorageName = tbStockProductInfo.getStorageNameByClass(Convert.ToInt32(StorageClassID));
if (StorageID == 0)
{
dList = tbProductsInfo.GetProductsStorageInfoByStorageID(Convert.ToInt32(StorageClassID), StorageID, sDate, ProductID);
}
else
{
dList = tbProductsInfo.GetProductsStorageInfoByStorageID(0, StorageID, sDate, ProductID); // DataUtils.GetStock_analysis(0, DateTime.Now, ProductID);
}
if (dList.Rows.Count > 0)
{
DataColumn dc = dList.Columns.Add("pPrice", Type.GetType("System.Decimal"));
dc.DefaultValue = 0;
DataColumn dc2 = dList.Columns.Add("pPriceRMB", Type.GetType("System.Decimal"));
dc2.DefaultValue = 0;
for (int k = 0; k < priceList.Rows.Count; k++)
{
for (int j = 0; j < dList.Rows.Count; j++)
{
if (dList.Rows [j] ["ProductsID"].ToString() == priceList.Rows [k] ["ProductsID"].ToString())
{
dList.Rows [j] ["pPrice"] = Convert.ToDecimal(priceList.Rows [k] ["Price"]);
dList.Rows [j] ["pPriceRMB"] = Convert.ToDecimal(priceList.Rows [k] ["PriceRMB"]);
}
}
}
dList.AcceptChanges();
}
}
}
//更新成本
if (Act == "UpdatePrice")
{
ProductID = HTTPRequest.GetInt("ProductID", 0);
Price = Convert.ToDecimal(HTTPRequest.GetFloat("Price", 0));
PriceRMB = Convert.ToDecimal(HTTPRequest.GetFloat("PriceRMB", 0));
if (ProductID > 0)
{
ProductPriceNOAutoInfo pp = new ProductPriceNOAutoInfo();
pp.ProductsID = ProductID;
pp.Price = Price;
pp.PriceRMB = PriceRMB;
pp.ppAppendTime = DateTime.Now;
if (tbProductPriceNOAuto.AddProductPriceNOAuto(pp) > 0)
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:true,ProductsID:" + ProductID + ",Price:" + Price + "}");
Response.End();
}
}
}
if (ispost)
{
Act = HTTPRequest.GetFormString("Act");
S_key = Utils.ChkSQL(HTTPRequest.GetFormString("S_key"));
}
else
{
S_key = Utils.ChkSQL(HTTPRequest.GetQueryString("S_key"));
//导出
if (Act.IndexOf("Export") > -1)
{
DataTable dt = dList.Copy();
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
dt.Rows[j]["pStorage"] = (Convert.ToDecimal(dt.Rows[j]["pStorage"].ToString()) + Convert.ToDecimal(dt.Rows[j]["pStorageIn"].ToString()) - Convert.ToDecimal(dt.Rows[j]["pStorageOut"].ToString()) + Convert.ToDecimal(dt.Rows[j]["Beginning"].ToString())).ToString();
}
dt.AcceptChanges();
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(7);
DataSet dset = new DataSet();
dt.Columns["sName"].SetOrdinal(0);
dset.Tables.Add(dt);
dset.Tables[0].Columns[0].ColumnName = "仓库名称";
dset.Tables[0].Columns[1].ColumnName = "商品条码";
dset.Tables[0].Columns[2].ColumnName = "商品名称";
dset.Tables[0].Columns[3].ColumnName = "默认售价";
dset.Tables[0].Columns[4].ColumnName = "库存数量";
dset.Tables[0].Columns[5].ColumnName = "入库未核销";
dset.Tables[0].Columns[6].ColumnName = "出库未核销";
dset.Tables[0].Columns[7].ColumnName = "不可用库存";
dset.Tables[0].Columns[8].ColumnName = "成本(€)";
dset.Tables[0].Columns[9].ColumnName = "成本(¥)";
CreateExcel(dset.Tables[0], "Data_" + sDate.ToShortDateString() + ".xls");
}
else
{
AddErrLine("请选择仓库类别后再进行查询!");
}
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("8-3-2-1"))
{
Act = HTTPRequest.GetString("Act");
m_TradeInfoID_Str = HTTPRequest.GetString("m_TradeInfoID");
if (m_TradeInfoID_Str.Trim() != "")
{
m_TradeInfoID_Str = Utils.ReSQLSetTxt("," + m_TradeInfoID_Str + ",");
if (ispost)
{
OrderInfo oi = new OrderInfo();
string receiver_state = Utils.ChkSQL(HTTPRequest.GetString("receiver_state"));
string receiver_city = Utils.ChkSQL(HTTPRequest.GetString("receiver_city"));
string receiver_district = Utils.ChkSQL(HTTPRequest.GetString("receiver_district"));
string receiver_address = Utils.ChkSQL(HTTPRequest.GetString("receiver_address"));
string receiver_zip = Utils.ChkSQL(HTTPRequest.GetString("receiver_zip"));
string receiver_name = Utils.ChkSQL(HTTPRequest.GetString("receiver_name"));
string receiver_mobile = Utils.ChkSQL(HTTPRequest.GetString("receiver_mobile"));
string receiver_phone = Utils.ChkSQL(HTTPRequest.GetString("receiver_phone"));
string from_name = Utils.ChkSQL(HTTPRequest.GetString("from_name"));
string from_state = Utils.ChkSQL(HTTPRequest.GetString("from_state"));
string from_city = Utils.ChkSQL(HTTPRequest.GetString("from_city"));
string from_district = Utils.ChkSQL(HTTPRequest.GetString("from_district"));
string from_address = Utils.ChkSQL(HTTPRequest.GetString("from_address"));
string from_zip = Utils.ChkSQL(HTTPRequest.GetString("from_zip"));
string from_mobile = Utils.ChkSQL(HTTPRequest.GetString("from_mobile"));
string from_phone = Utils.ChkSQL(HTTPRequest.GetString("from_phone"));
int ExpName = HTTPRequest.GetInt("ExpName", 0);
string ExpNO = Utils.ChkSQL(HTTPRequest.GetString("ExpNO"));
string tMsg = Utils.ChkSQL(HTTPRequest.GetString("tMsg"));
int m_SendGoodsID = HTTPRequest.GetInt("m_SendGoodsID", 0);
string _OrderListDataJson = HTTPRequest.GetString("OrderListDataJson");
//创建发货单
if (Act == "Add")
{
try {
oi.oOrderNum = "----------";// Orders.GetNewOrderNum();
//if (!Orders.ExistsOrderInfo(oi.oOrderNum))
{
oi.oType = 3; //销售发货单
oi.StoresID = M_Config.StoresID; //系统客户编号
oi.oCustomersName = M_Config.StoresName; //客户名称,
oi.oCustomersContact = receiver_name; //联系人
oi.oCustomersTel = receiver_mobile + "," + receiver_phone; //联系电话
oi.oCustomersAddress = receiver_address; //地址
oi.oCustomersOrderID = m_TradeInfoID_Str; //客户订单号
oi.oCustomersNameB = "";
oi.StaffID = 0; //业务员暂留空
oi.UserID = this.userid;
oi.oAppendTime = DateTime.Now;
oi.oOrderDateTime = DateTime.Now;
oi.oState = 0;
oi.oSteps = 1;
oi.oPrepay = 0;
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
int OrderID = Orders.AddOrderInfoAndList(oi);
if (OrderID > 0)
{
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = OrderID;
owl.UserID = this.userid;
owl.oType = 0;
owl.oMsg = M_Config.StoresName + "-" + M_Config.m_Name + ",下单:" + m_TradeInfoID_Str;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
//网店发货单
SendGoods.m_ConfigInfoID = M_Config.m_ConfigInfoID;
SendGoods.OrderID = OrderID;
SendGoods.m_TradeInfoID = m_TradeInfoID_Str;
SendGoods.receiver_name = receiver_name;
SendGoods.receiver_state = receiver_state;
SendGoods.receiver_city = receiver_city;
SendGoods.receiver_district = receiver_district;
SendGoods.receiver_address = receiver_address;
SendGoods.receiver_zip = receiver_zip;
SendGoods.receiver_mobile = receiver_mobile;
SendGoods.receiver_phone = receiver_phone;
SendGoods.from_name = M_Config.StoresName;
SendGoods.from_state = from_state;
SendGoods.from_city = from_city;
SendGoods.from_district = from_district;
SendGoods.from_address = from_address;
SendGoods.from_zip = from_zip;
SendGoods.from_mobile = from_mobile;
SendGoods.from_phone = from_phone;
SendGoods.mExpName = ExpName;
SendGoods.mExpNO = ExpNO;
SendGoods.mMemo = tMsg;
SendGoods.mState = 0;
SendGoods.mAppendTime = DateTime.Now;
m_SendGoodsID = M_Utils.AddM_SendGoodsInfo(SendGoods);
if (m_SendGoodsID > 0)
{
AddMsgLine("单据创建成功!<p class=\"SendGood\"><br>查看发货单据?-><a href=\"javascript:void(0);\" onclick=\"javascript:OrderDO.Show(" + OrderID + ");\">查看</a></p>");
#region 发送邮件给审核人员
try
{
oi = Orders.GetOrderInfoModel(OrderID);
UsersUtils.SendUserMailByPopedom("3-2-1-2", "销售发货单 需审核,单号:" + oi.oOrderNum, "销售发货单 需审核,单号:" + oi.oOrderNum);
}
catch
{
}
#endregion
}
else //网店订单生成失败,作废系统订单
{
oi = Orders.GetOrderInfoModel(OrderID);
oi.oState = 1;
Orders.UpdateOrderInfo(oi);
tbProductsInfo.UpdateProductsStorageByOrderID(OrderID);//更新当前在途库存情况
OrderWorkingLogInfo _owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = -1;
owl.oMsg = "网店订单生成失败,系统自动作废发货单!网店单号:" + m_TradeInfoID_Str;
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
}
}
else
{
AddErrLine("新建单据失败,请重试!");
}
}
//else
{
// AddErrLine("发货单据号重复,单据添加失败,请重试!");
}
}
finally
{
oi = null;
}
}
//修改操作
if (Act == "Edit")
{
int m_TradeInfoID = HTTPRequest.GetInt("m_TradeInfoID", 0);
SendGoods = M_Utils.GetM_SendGoodsInfoModelBym_TradeInfoID(m_TradeInfoID);
if (SendGoods != null)
{
oi = Orders.GetOrderInfoModel(SendGoods.OrderID);
oi.oCustomersContact = receiver_name; //联系人
oi.oCustomersTel = receiver_mobile + "," + receiver_phone; //联系电话
oi.oCustomersAddress = receiver_address; //地址
oi.StaffID = 0; //业务员暂留空
oi.OrderListDataJson = (OrderListDataJson)JavaScriptConvert.DeserializeObject(_OrderListDataJson, typeof(OrderListDataJson));
if (Orders.UpdateOrderInfoAndList(oi))
{
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 1;
owl.oMsg = "网购订单修改操作!";
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
SendGoods.receiver_name = receiver_name;
SendGoods.receiver_state = receiver_state;
SendGoods.receiver_city = receiver_city;
SendGoods.receiver_district = receiver_district;
SendGoods.receiver_address = receiver_address;
SendGoods.receiver_zip = receiver_zip;
SendGoods.receiver_mobile = receiver_mobile;
SendGoods.receiver_phone = receiver_phone;
SendGoods.from_name = M_Config.StoresName;
SendGoods.from_state = from_state;
SendGoods.from_city = from_city;
SendGoods.from_district = from_district;
SendGoods.from_address = from_address;
SendGoods.from_zip = from_zip;
SendGoods.from_mobile = from_mobile;
SendGoods.from_phone = from_phone;
SendGoods.mExpName = ExpName;
SendGoods.mExpNO = ExpNO;
SendGoods.mMemo = tMsg;
M_Utils.UpdateM_SendGoodsInfo(SendGoods);
AddMsgLine("更新成功!");
}
else
{
AddErrLine("发货单更新失败!");
}
}
else
{
AddErrLine("参数错误!");
}
}
}
else
{
Sender = tbStoresInfo.GetStoresInfoModel(M_Config.StoresID);
if (Act == "Edit")
{
//取 TradeID
int m_TradeInfoID = HTTPRequest.GetInt("m_TradeInfoID", 0);
SendGoods = M_Utils.GetM_SendGoodsInfoModelBym_TradeInfoID(m_TradeInfoID);
if (SendGoods != null)
{
SendGoods.m_TradeInfoID = Utils.ReSQLSetTxt("0," + SendGoods.m_TradeInfoID + ",");
tList = M_Utils.GetM_TradeInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + SendGoods.m_TradeInfoID + ")").Tables[0];
oList = M_Utils.GetM_OrderInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + SendGoods.m_TradeInfoID + ")").Tables[0];
DataTable OrderListData = Orders.GetOrderListInfoList(" OrderID=" + SendGoods.OrderID + " and oWorkType=1 order by OrderListID asc").Tables[0];
if (OrderListData != null)
{
foreach (DataRow dr_OrderListData in OrderListData.Rows)
{
OrderListDataJsonStr += "{\"OrderListID\":" + dr_OrderListData["OrderListID"].ToString() + "," +
"\"OrderID\":" + dr_OrderListData["OrderID"].ToString() + "," +
"\"StorageID\":" + dr_OrderListData["StorageID"].ToString() + "," +
"\"StorageName\":\"" + dr_OrderListData["StorageName"].ToString() + "\"," +
"\"ProductsID\":" + dr_OrderListData["ProductsID"].ToString() + "," +
"\"ProductsName\":\"" + dr_OrderListData["ProductsName"].ToString() + "\"," +
"\"oQuantity\":" + dr_OrderListData["oQuantity"].ToString() + "," +
"\"oPrice\":" + dr_OrderListData["oPrice"].ToString() + "," +
"\"oMoney\":" + dr_OrderListData["oMoney"].ToString() + "," +
"\"StoresSupplierID\":" + dr_OrderListData["StoresSupplierID"].ToString() + "," +
"\"IsPromotions\":" + dr_OrderListData["IsPromotions"].ToString() + "," +
"\"oWorkType\":" + dr_OrderListData["oWorkType"].ToString() + "," +
"\"IsGifts\":" + dr_OrderListData["IsGifts"].ToString() + "," +
"\"PriceClassID\":" + dr_OrderListData["PriceClassID"].ToString() + "," +
"\"oAppendTime\":\"" + dr_OrderListData["oAppendTime"].ToString() + "\"},";
}
if (OrderListDataJsonStr.Trim() != "")
{
OrderListDataJsonStr = "{\"OrderListJson\":[" + Utils.ReSQLSetTxt(OrderListDataJsonStr) + "]}";
}
}
}
else
{
AddErrLine("该交易的发货单不存在!");
}
}
else
{
oList = M_Utils.GetM_OrderInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + m_TradeInfoID_Str + ")").Tables[0];
tList = M_Utils.GetM_TradeInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " and m_TradeInfoID in(" + m_TradeInfoID_Str + ")").Tables[0];
}
eList = M_Utils.GetM_ExpressTemplatesInfoList(" m_ConfigInfoID=" + M_Config.m_ConfigInfoID + " order by mAppendTime desc").Tables[0];
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
int uid = -1;
UserInfo ui = new UserInfo();
postusername = Utils.ChkSQL(HTTPRequest.GetString("username"));
postpassword = Utils.ChkSQL(HTTPRequest.GetString("password"));
if (!ispost)
{
if (this.userid > 0)
{
AddErrLine("您已经登录，无需重复登录。");
AddScript("window.setTimeout(function(){top.location='Default.aspx';},1500);");
SetShowMsgLink(false);
}
}
else
{
try
{
if (postpassword.Equals(""))
{
AddErrLine("密码不能为空");
}
else
{
if (postusername.Equals(""))
{
AddErrLine("用户名不能为空");
}
else
{
if (BLL.tbUserInfo.ExistsUserInfo(postusername))
{
uid = BLL.tbUserInfo.CheckPassword(postusername, postpassword, true);
if (uid != -1)
{
UserInfo tui = BLL.tbUserInfo.GetUserInfoModel(uid);
if (tui.uEstate == 1)
{
AddErrLine("抱歉, 您的用户身份尚未得到验证");
}
if (!IsErr())
{
BLL.tbUserInfo.DeleteErrLoginRecord(this.GetIP());
tui.uLastIP = this.GetIP();
tui.uUpAppendTime = DateTime.Now;
BLL.tbUserInfo.UpdateUserInfo(tui);
UsersUtils.WriteUserCookie(uid, Utils.StrToInt(HTTPRequest.GetString("expires"), -1), config.Passwordkey, HTTPRequest.GetInt("loginmode", -1));
UsersUtils.WriteCookie("UserPKey", DES.Encode(postpassword, config.Passwordkey));
AddMsgLine("登录成功,页面转接中,请稍后!");
AddScript("window.setTimeout(function(){top.location='Default.aspx';},1000);");
SetShowMsgLink(false);
}
}
else
{
CheckPassErrorCount();
}
}
else
{
AddErrLine("用户不存在");
}
}
}
if (IsErr())
{
AddScript("window.setTimeout(function(){window.history.go(-1);},1500);");
SetShowMsgLink(false);
}
}
finally
{
ui = null;
}
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
pagesize = 20;
PageBarHTML = "";
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-4-1-2"))
{
pagecode = Utils.GetRanDomCode().Trim();
UsersUtils.WriteCookie("OrderPageCode", pagecode);
if (HTTPRequest.GetString("page").Trim() != "" && Utils.IsInt(HTTPRequest.GetString("page").Trim()))
{
pageindex = int.Parse(HTTPRequest.GetString("page").Trim());
}
else
{
pageindex = 1;
}
if (Act == "Edit")
{
StockID = Utils.StrToInt(HTTPRequest.GetString("sid"), 0);
si = tbStockProductInfo.GetInventoryInfoModel(StockID);
if (ispost)
{
DateTime sDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("dtime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("dtime"))) : DateTime.Now;
string InventoryName = Utils.ChkSQL(HTTPRequest.GetString("InventoryName")); //盘点人
string ManagerName = Utils.ChkSQL(HTTPRequest.GetString("ManagerName")); //仓管员
string sTel = Utils.ChkSQL(HTTPRequest.GetString("sTel"));
string sAddress = Utils.ChkSQL(HTTPRequest.GetString("sAddress"));
string reValue = HTTPRequest.GetString("reValue");
si.SAppendTime = sDate;
si.StorageStaff = ManagerName;
si.StaffPhoneNum = sTel;
si.StaffAdress = sAddress;
si.InventoryName = InventoryName;
si.GetWarehouseDateJson = (GetWarehouseDateJsonList)JavaScriptConvert.DeserializeObject(reValue, typeof(GetWarehouseDateJsonList));
bool state = tbStockProductInfo.UpdateWarehouseList(si);
if (state)
{
AddErrLine("修改数据成功！");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("修改数据失败！");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
//ssi = tbStorageInfo.GetStorageInfoModel(si.StorageID);
dList = tbStockProductInfo.getInventoryInfoList(si.StorageID, si.SDateTime);
PageBarHTML = Utils.TenPage(pageindex, pagetotal, 0);
}
}
}
else
{
AddErrLine("权限不足! ");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("4-1"))
{
ucode = DES.Encode(this.userinfo.uName + "|" + UsersUtils.GetCookiePassword(config.Passwordkey), config.Passwordkey);
Act = HTTPRequest.GetString("Act");
StaffID = Utils.StrToInt(HTTPRequest.GetString("sid"), 0);
format = HTTPRequest.GetString("format");
if (Act == "Edit")
{
si = tbStaffInfo.GetStaffInfoModel(StaffID);
sd = tbStaffInfo.GetStaffDataInfoModelByStaffID(StaffID);
if (sd != null)
{
sd.sBirthDay = sd.sBirthDay != null?sd.sBirthDay:"";
sd.sPolitical = sd.sPolitical != null ? sd.sPolitical : "";
sd.sBirthplace = sd.sBirthplace != null ? sd.sBirthplace : "";
sd.sHometown = sd.sHometown != null ? sd.sHometown : "";
sd.sEducation = sd.sEducation != null ? sd.sEducation : "";
sd.sProfessional = sd.sProfessional != null ? sd.sProfessional : "";
sd.sHealth = sd.sHealth != null ? sd.sHealth : "";
sd.sSpecialty = sd.sSpecialty != null ? sd.sSpecialty : "";
sd.sHobbies = sd.sHobbies != null ? sd.sHobbies : "";
sd.sContactAddress = sd.sContactAddress != null ? sd.sContactAddress : "";
sd.sPhotos = sd.sPhotos != null ? sd.sPhotos : "";
sd.sCanBeDate = sd.sCanBeDate != null ? sd.sCanBeDate : "";
}
sad = tbStaffInfo.GetStaffAnalysisDataInfoModelByStaffID(StaffID);
if (sad != null)
{
sad.aEvaluationMSG = sad.aEvaluationMSG != null ? sad.aEvaluationMSG : "";
}
}
//修改状体
if (Act == "State")
{
si = tbStaffInfo.GetStaffInfoModel(StaffID);
tJson = ",\"StaffID\":" + StaffID + "";
if (si != null)
{
si.sState = (si.sState == 0 ? 1 : 0);
tbStaffInfo.UpdateStaffInfo(si);
Logs.AddEventLog(this.userid, "修改人员状态." + si.sName);
tJson += ",\"StaffState\":" + si.sState;
AddMsgLine("修改成功!");
}
else
{
AddErrLine("修改失败,对象不存在!");
}
}
if (ispost)
{
sName = Utils.ChkSQL(HTTPRequest.GetString("sName"));
sSex = Utils.ChkSQL(HTTPRequest.GetString("sSex"));
sTel = Utils.ChkSQL(HTTPRequest.GetString("sTel"));
sCarID = Utils.ChkSQL(HTTPRequest.GetString("sCarID"));
sType = Utils.StrToInt(HTTPRequest.GetString("sType"), 0);
sEmail = Utils.ChkSQL(HTTPRequest.GetString("sEmail"));
DepartmentsClassID = Utils.StrToInt(HTTPRequest.GetString("DepartmentsClassID"), 0);
sState = HTTPRequest.GetString("sState").Trim() != "" ? Utils.StrToInt(HTTPRequest.GetString("sState"), 0) : 1;
si.sSex = sSex;
si.sTel = sTel;
si.sCarID = sCarID;
si.sType = sType;
si.sState = sState;
si.sEmail = sEmail;
si.DepartmentsClassID = DepartmentsClassID;
sd = sd != null ? sd : new StaffDataInfo();
sd.sBirthDay = Utils.ChkSQL(HTTPRequest.GetString("sBirthDay"));
sd.sPolitical = Utils.ChkSQL(HTTPRequest.GetString("sPolitical"));
sd.sBirthplace = Utils.ChkSQL(HTTPRequest.GetString("sBirthplace"));
sd.sHometown = Utils.ChkSQL(HTTPRequest.GetString("sHometown"));
sd.sEducation = Utils.ChkSQL(HTTPRequest.GetString("sEducation"));
sd.sProfessional = Utils.ChkSQL(HTTPRequest.GetString("sProfessional"));
sd.sHealth = Utils.ChkSQL(HTTPRequest.GetString("sHealth"));
sd.sHeight = HTTPRequest.GetInt("sHeight", 0);
sd.sWeight = HTTPRequest.GetInt("sWeight", 0);
sd.sSpecialty = Utils.ChkSQL(HTTPRequest.GetString("sSpecialty"));
sd.sHobbies = Utils.ChkSQL(HTTPRequest.GetString("sHobbies"));
sd.sContactAddress = Utils.ChkSQL(HTTPRequest.GetString("sContactAddress"));
sd.sPhotos = Utils.ChkSQL(HTTPRequest.GetString("sPhotos"));
sd.sEmployment = HTTPRequest.GetInt("sEmployment", 0);
sd.sCanBeDate = Utils.ChkSQL(HTTPRequest.GetString("sCanBeDate"));
sd.sTreatment = HTTPRequest.GetInt("sTreatment", 0);
sad = sad != null ? sad : new StaffAnalysisDataInfo();
sad.aWearing = HTTPRequest.GetInt("aWearing", 0);
sad.aEducation = HTTPRequest.GetInt("aEducation", 0);
sad.aWork = HTTPRequest.GetInt("aWork", 0);
sad.aCommunication = HTTPRequest.GetInt("aCommunication", 0);
sad.aConfidence = HTTPRequest.GetInt("aConfidence", 0);
sad.aLeadership = HTTPRequest.GetInt("aLeadership", 0);
sad.aJobstability = HTTPRequest.GetInt("aJobstability", 0);
sad.aComputer = HTTPRequest.GetInt("aComputer", 0);
sad.aEnglish = HTTPRequest.GetInt("aEnglish", 0);
sad.aWritten = HTTPRequest.GetInt("aWritten", 0);
sad.aEvaluation = HTTPRequest.GetInt("aEvaluation", 0);
sad.aEvaluationMSG = Utils.ChkSQL(HTTPRequest.GetString("aEvaluationMSG"));
try
{
sad.aDateTime = Utils.IsDateString(HTTPRequest.GetString("aDateTime")) ? DateTime.Parse(HTTPRequest.GetString("aDateTime").Trim()) : DateTime.Now;
}
catch {
sad.aDateTime = DateTime.Now;
}
EduDataListJson = HTTPRequest.GetString("EduDataListJson");
WorkDataListJson = HTTPRequest.GetString("WorkDataListJson");
FamilyDataListJson = HTTPRequest.GetString("FamilyDataListJson");
if (Act == "Add")
{
if (!tbStaffInfo.ExistsStaffInfo(sName))
{
si.sName = sName;
si.sAppendTime = sAppendTime;
StaffID = tbStaffInfo.AddStaffInfo(si);
if (StaffID > 0)
{
sd.StaffID = StaffID;
tbStaffInfo.AddStaffDataInfo(sd);
sad.StaffID = StaffID;
sad.aAppendTime = DateTime.Now;
tbStaffInfo.AddStaffAnalysisDataInfo(sad);
if (EduDataListJson.Trim() != "")
{
StaffEduDataJson EduDataJson = (StaffEduDataJson)JavaScriptConvert.DeserializeObject(EduDataListJson, typeof(StaffEduDataJson));
tbStaffInfo.AddStaffEduDataInfoByJson(EduDataJson);
}
if (WorkDataListJson.Trim() != "")
{
StaffWorkDataJson WorkDataJson = (StaffWorkDataJson)JavaScriptConvert.DeserializeObject(WorkDataListJson, typeof(StaffWorkDataJson));
tbStaffInfo.AddStaffWorkDataInfoByJson(WorkDataJson);
}
if (FamilyDataListJson.Trim() != "")
{
StaffFamilyDataJson FamilyDataJson = (StaffFamilyDataJson)JavaScriptConvert.DeserializeObject(FamilyDataListJson, typeof(StaffFamilyDataJson));
tbStaffInfo.AddStaffFamilyDataInfoByJson(FamilyDataJson);
}
Logs.AddEventLog(this.userid, "新增人员." + si.sName);
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("人员:" + sName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',3000);");
}
}
if (Act == "Edit")
{
bool nOK = false;
if (si.sName.Trim() != sName.Trim())
{
if (!tbStaffInfo.ExistsStaffInfo(sName.Trim()))
{
nOK = true;
}
else
{
nOK = false;
AddErrLine("人员:" + sName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',3000);");
}
}
else
{
nOK = true;
}
if (nOK)
{
try
{
si.sName = sName;
tbStaffInfo.UpdateStaffInfo(si);
if (sd.StaffID > 0)
{
tbStaffInfo.UpdateStaffDataInfo(sd);
}
else
{
sd.StaffID = StaffID;
tbStaffInfo.AddStaffDataInfo(sd);
}
if (sad.StaffID > 0)
{
tbStaffInfo.UpdateStaffAnalysisDataInfo(sad);
}
else
{
sad.StaffID = StaffID;
sad.aAppendTime = DateTime.Now;
tbStaffInfo.AddStaffAnalysisDataInfo(sad);
}
if (EduDataListJson.Trim() != "")
{
StaffEduDataJson EduDataJson = (StaffEduDataJson)JavaScriptConvert.DeserializeObject(EduDataListJson, typeof(StaffEduDataJson));
tbStaffInfo.UpdateStaffEduDataInfoByJson(EduDataJson, StaffID);
}
if (WorkDataListJson.Trim() != "")
{
StaffWorkDataJson WorkDataJson = (StaffWorkDataJson)JavaScriptConvert.DeserializeObject(WorkDataListJson, typeof(StaffWorkDataJson));
tbStaffInfo.UpdateStaffWorkDataInfoByJson(WorkDataJson, StaffID);
}
if (FamilyDataListJson.Trim() != "")
{
StaffFamilyDataJson FamilyDataJson = (StaffFamilyDataJson)JavaScriptConvert.DeserializeObject(FamilyDataListJson, typeof(StaffFamilyDataJson));
tbStaffInfo.UpdateStaffFamilyDataInfoByJson(FamilyDataJson, StaffID);
}
Logs.AddEventLog(this.userid, "修改人员." + si.sName);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
//AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
Caches.ReSet();
}
else
{
DepartmentsClass = Caches.GetDepartmentsClassInfoToHTML();
if (Act == "Add")
{
si.sName = "";
si.sSex = "男";
si.sState = 0;
si.sType = 0;
}
if (Act == "Edit")
{
EduDataListJson = "";
WorkDataListJson = "";
FamilyDataListJson = "";
EduDataList = tbStaffInfo.GetStaffEduDataInfoList(" StaffID=" + StaffID + " order by StaffEduDataID desc").Tables[0];
StaffWorkDataList = tbStaffInfo.GetStaffWorkDataInfoList(" StaffID=" + StaffID + " order by StaffWorkDataID desc").Tables[0];
StaffFamilyDataList = tbStaffInfo.GetStaffFamilyDataInfoList(" StaffID=" + StaffID + " order by StaffFamilyDataID desc").Tables[0];
try {
foreach (DataRow dr in EduDataList.Rows)
{
EduDataListJson += "{\"StaffEduDataID\":\"" + dr["StaffEduDataID"].ToString() + "\",\"StaffID\":\"" + dr["StaffID"].ToString() + "\",\"eDate\":\"" + dr["eDate"].ToString() + "\",\"eSchools\":\"" + dr["eSchools"].ToString().Replace("\"", "\\\"") + "\",\"eContent\":\"" + dr["eContent"].ToString().Replace("\"", "\\\"") + "\"},";
}
if (EduDataListJson.Trim() != "")
{
EduDataListJson = EduDataListJson.Substring(0, EduDataListJson.Length - 1);
}
EduDataListJson = "{\"EduDataList\":[" + EduDataListJson + "]}";
foreach (DataRow dr in StaffWorkDataList.Rows)
{
WorkDataListJson += "{\"StaffWorkDataID\":\"" + dr["StaffWorkDataID"].ToString() + "\",\"StaffID\":\"" + dr["StaffID"].ToString() + "\",\"wDate\":\"" + dr["wDate"].ToString() + "\",\"wEnterprise\":\"" + dr["wEnterprise"].ToString().Replace("\"", "\\\"") + "\",\"wTel\":\"" + dr["wTel"].ToString().Replace("\"", "\\\"") + "\",\"wJobs\":\"" + dr["wJobs"].ToString().Replace("\"", "\\\"") + "\",\"wIncome\":\"" + dr["wIncome"].ToString().Replace("\"", "\\\"") + "\"},";
}
if (WorkDataListJson.Trim() != "")
{
WorkDataListJson = WorkDataListJson.Substring(0, WorkDataListJson.Length - 1);
}
WorkDataListJson = "{\"WorkDataList\":[" + WorkDataListJson + "]}";
foreach (DataRow dr in StaffFamilyDataList.Rows)
{
FamilyDataListJson += "{\"StaffFamilyDataID\":\"" + dr["StaffFamilyDataID"].ToString() + "\",\"StaffID\":\"" + dr["StaffID"].ToString() + "\",\"fTitle\":\"" + dr["fTitle"].ToString() + "\",\"fName\":\"" + dr["fName"].ToString().Replace("\"", "\\\"") + "\",\"fAge\":\"" + dr["fAge"].ToString().Replace("\"", "\\\"") + "\",\"fEnterprise\":\"" + dr["fEnterprise"].ToString().Replace("\"", "\\\"") + "\",\"fWork\":\"" + dr["fWork"].ToString().Replace("\"", "\\\"") + "\",\"fAddress\":\"" + dr["fAddress"].ToString().Replace("\"", "\\\"") + "\",\"fTel\":\"" + dr["fTel"].ToString().Replace("\"", "\\\"") + "\"},";
}
if (FamilyDataListJson.Trim() != "")
{
FamilyDataListJson = FamilyDataListJson.Substring(0, FamilyDataListJson.Length - 1);
}
FamilyDataListJson = "{\"FamilyDataList\":[" + FamilyDataListJson + "]}";
}
finally {
EduDataList = null;
StaffWorkDataList = null;
StaffFamilyDataList = null;
}
}
if (Act == "Del")
{
try
{
tbStaffInfo.DeleteStaffInfo(HTTPRequest.GetString("sid"));
Logs.AddEventLog(this.userid, "删除人员." + HTTPRequest.GetString("sid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
if (format == "json")
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/json";
string Json_Str = "{\"results\": {\"msg\":\"" + this.msgbox_text + "\",\"state\":\"" + (!IsErr()).ToString() + "\"" + tJson + "}}";
Response.Write(Json_Str);
Response.End();
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
UserTypeList = Caches.GetUserTypeList();
Act = HTTPRequest.GetString("Act");
uName = Utils.ChkSQL(HTTPRequest.GetString("uName"));
uPWD = Utils.ChkSQL(HTTPRequest.GetString("uPWD"));
uPWD_Old = Utils.ChkSQL(HTTPRequest.GetString("uPWD_Old"));
uPermissions = Utils.ChkSQL(HTTPRequest.GetString("uPermissions"));
uEstate = Utils.ChkSQL(HTTPRequest.GetString("uEstate"));
Erp_Name = Utils.ChkSQL(HTTPRequest.GetString("Erp_Name"));
Erp_Pwd = Utils.ChkSQL(HTTPRequest.GetString("Erp_Pwd"));
g_Name = Utils.ChkSQL(HTTPRequest.GetString("g_Name"));
g_PWD = Utils.ChkSQL(HTTPRequest.GetString("g_PWD"));
uType = HTTPRequest.GetInt("uType", 0);
StaffID = HTTPRequest.GetInt("StaffID", 0);
StorageIDStr = Utils.ChkSQL(HTTPRequest.GetString("StorageIDStr"));
StorageIDStr = StorageIDStr.IndexOf("x") > -1 ? "x" : "," + StorageIDStr + ",";
pi.Erp_Name = "";
pi.Erp_Pwd = "";
pi.g_Name = "";
pi.g_PWD = "";
if (Act == "Edit")
{
UserID = Utils.StrToInt(HTTPRequest.GetString("uid"), 0);
ui = tbUserInfo.GetUserInfoModel(UserID);
pi = tbUserInfo.GetUserPassportInfoModel(UserID);
if (pi == null)
{
pi = new UserPassportInfo();
pi.Erp_Name = "";
pi.Erp_Pwd = "";
pi.g_Name = "";
pi.g_PWD = "";
}
UserPopedomJson = UsersUtils.GetUserPopedomToJsonStr();// UsersUtils.GetUserPopedomToJsonStr(ui.uPermissions);
}
if (ispost)
{
if (ui.uPermissions != "X")
{
ui.uPermissions = uPermissions;
}
ui.uEstate = uEstate == "0" ? 0 : 1;
ui.uType = uType;
ui.StaffID = StaffID;
ui.StorageIDStr = StorageIDStr;
if (Act == "Add")
{
if (!tbUserInfo.ExistsUserInfo(uName))
{
ui.uName = uName;
ui.uPWD = Utils.MD5(uPWD);
ui.uCode = Utils.CutString(Utils.GetRanDomCode(), 16);
ui.uLastIP = HTTPRequest.GetIP();
ui.uAppendTime = DateTime.Now;
ui.uUpAppendTime = DateTime.Now;
pi.UserID = tbUserInfo.AddUserInfo(ui);
Logs.AddEventLog(this.userid, "新增用户:" + ui.uName);
if (pi.UserID > 0)
{
pi.Erp_Name = Erp_Name;
pi.Erp_Pwd = Erp_Pwd;
pi.g_Name = g_Name;
pi.g_PWD = g_PWD;
if (tbUserInfo.AddUserPassportInfo(pi) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("账户创建成功,但通行证绑定失败!");
AddScript("history.back(1);");
}
}
else
{
AddErrLine("创建失败!");
AddScript("history.back(1);");
}
}
else
{
AddErrLine("用户名:" + uName + ",已存在,请更换!");
AddScript("history.back(1);");
}
}
if (Act == "Edit")
{
if (UserID > 0)
{
ui.UserID = UserID;
if (uPWD.Trim() != "")
{
ui.uPWD = Utils.MD5(uPWD);
}
else
{
ui.uPWD = uPWD_Old;
}
//超级管理员无需修改权限与状态
if (ui.uPermissions == "X")
{
ui.uPermissions = "X";
ui.uEstate = 0;
}
try
{
pi.UserID = UserID;
pi.Erp_Name = Erp_Name;
pi.Erp_Pwd = Erp_Pwd;
pi.g_Name = g_Name;
pi.g_PWD = g_PWD;
if (tbUserInfo.UserPassportInfoExists(UserID))
{
tbUserInfo.UpdateUserPassportInfo(pi);
}
else
{
tbUserInfo.AddUserPassportInfo(pi);
}
tbUserInfo.UpdateUserInfo(ui);
Logs.AddEventLog(this.userid, "修改用户:" + ui.uName);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("参数错误,修改失败!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
StorageList = tbStorageInfo.GetStorageInfoList(" sState = 0").Tables [0];
if (Act == "Add")
{
ui.UserID = 0;
ui.uName = "";
ui.uPWD = "";
ui.uCode = "";
ui.uEstate = 0;
ui.uPermissions = "";
ui.StorageIDStr = "x";
UserPopedomJson = UsersUtils.GetUserPopedomToJsonStr();
}
if (Act == "Del")
{
try
{
tbUserInfo.DeleteUserInfo(HTTPRequest.GetString("uid"));
Logs.AddEventLog(this.userid, "删除用户:uid=>" + HTTPRequest.GetString("uid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.parent.HidBox();");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
Classid = HTTPRequest.GetInt("Classid", 0);
name = HTTPRequest.GetString("cName");
Popedoms = HTTPRequest.GetString("Popedoms");
Act = HTTPRequest.GetString("Act");
if (!ispost)
{
UserPopedomJson = UsersUtils.GetUserPopedomToJsonStr();
if (Act == "Edit")
{
if (Classid > 0)
{
DataTable UserTypeList = UsersUtils.GetUserType();
foreach (DataRow dr in UserTypeList.Rows)
{
if (Classid == int.Parse(dr["id"].ToString()))
{
name = dr["name"].ToString().Trim();
Popedoms = dr["Popedoms"].ToString().Trim();
break;
}
}
}
else
{
AddErrLine("参数错误!");
}
}
if (Act == "Del")
{
if (Classid > 0)
{
DataTable UserTypeList = UsersUtils.GetUserType();
foreach (DataRow dr in UserTypeList.Rows)
{
if (Classid == Convert.ToInt32(dr["id"].ToString()))
{
dr.Delete();
break;
}
}
UserTypeList.AcceptChanges();
if (SaveDataToConfig(UserTypeList))
{
Logs.AddEventLog(this.userid, "删除用户组");
AddMsgLine("删除成功");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
else
{
AddErrLine("参数错误!");
}
}
}
else
{
if (Act == "Add")
{
DataTable UserTypeList = UsersUtils.GetUserType();
foreach (DataRow dr in UserTypeList.Rows)
{
if (name == dr["name"].ToString())
{
AddErrLine("用户组:" + name + ",已经存在!无法添加!");
break;
}
}
if (!IsErr())
{
DataRow[] dr = UserTypeList.Select("", "id desc");
if (dr.Length > 0)
{
Classid = Convert.ToInt32(dr[0]["id"]) + 1;
}
DataRow _dr = UserTypeList.NewRow();
_dr["Name"] = name;
_dr["ID"] = Classid;
_dr["Popedoms"] = Popedoms;
UserTypeList.Rows.Add(_dr);
UserTypeList.AcceptChanges();
if (SaveDataToConfig(UserTypeList))
{
Logs.AddEventLog(this.userid, "添加用户组");
AddMsgLine("添加成功");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
if (Act == "Edit")
{
if (Classid > 0)
{
DataTable UserTypeList = UsersUtils.GetUserType();
foreach (DataRow dr in UserTypeList.Rows)
{
if (Classid != Convert.ToInt32(dr["id"].ToString()))
{
if (name == dr["name"].ToString())
{
AddErrLine("用户组:" + name + ",已经存在!无法修改!");
break;
}
}
}
if (!IsErr())
{
foreach (DataRow dr in UserTypeList.Rows)
{
if (Classid == Convert.ToInt32(dr["id"].ToString()))
{
dr["name"] = name;
dr["Popedoms"] = Popedoms;
}
}
UserTypeList.AcceptChanges();
if (SaveDataToConfig(UserTypeList))
{
Logs.AddEventLog(this.userid, "修改用户组");
AddMsgLine("修改成功");
AddScript("window.setTimeout('window.parent.HidBox();',3000);");
}
}
}
else
{
AddErrLine("参数错误!");
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
}
