/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateM_ExpressTemplatesInfo(M_ExpressTemplatesInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_M_ExpressTemplatesInfo set ");
strSql.Append("mName=@mName,");
strSql.Append("mPIC=@mPIC,");
strSql.Append("mWidth=@mWidth,");
strSql.Append("mHeight=@mHeight,");
strSql.Append("mExpName=@mExpName,");
strSql.Append("mData=@mData,");
strSql.Append("mAppendTime=@mAppendTime,");
strSql.Append("m_ConfigInfoID=@m_ConfigInfoID");
strSql.Append(" where m_ExpressTemplatesID=@m_ExpressTemplatesID");
SqlParameter[] parameters =
{
new SqlParameter("@m_ExpressTemplatesID", SqlDbType.Int, 4),
new SqlParameter("@mName", SqlDbType.VarChar, 50),
new SqlParameter("@mPIC", SqlDbType.VarChar, 50),
new SqlParameter("@mWidth", SqlDbType.VarChar, 50),
new SqlParameter("@mHeight", SqlDbType.VarChar, 50),
new SqlParameter("@mExpName", SqlDbType.VarChar, 128),
new SqlParameter("@mData", SqlDbType.NText),
new SqlParameter("@mAppendTime", SqlDbType.DateTime),
new SqlParameter("@m_ConfigInfoID", SqlDbType.Int, 4),
};
parameters[0].Value = model.m_ExpressTemplatesID;
parameters[1].Value = model.mName;
parameters[2].Value = model.mPIC;
parameters[3].Value = model.mWidth;
parameters[4].Value = model.mHeight;
parameters[5].Value = model.mExpName;
parameters[6].Value = model.mData;
parameters[7].Value = model.mAppendTime;
parameters[8].Value = model.m_ConfigInfoID;
int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_ExpressTemplatesInfo GetM_ExpressTemplatesInfoModel(int m_ExpressTemplatesID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 m_ExpressTemplatesID,mName,mPIC,mWidth,mHeight,mExpName,mData,mAppendTime,m_ConfigInfoID from tb_M_ExpressTemplatesInfo ");
strSql.Append(" where m_ExpressTemplatesID=@m_ExpressTemplatesID");
SqlParameter[] parameters =
{
new SqlParameter("@m_ExpressTemplatesID", SqlDbType.Int, 4)
};
parameters[0].Value = m_ExpressTemplatesID;
M_ExpressTemplatesInfo model = new M_ExpressTemplatesInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["m_ExpressTemplatesID"].ToString() != "")
{
model.m_ExpressTemplatesID = int.Parse(ds.Tables[0].Rows[0]["m_ExpressTemplatesID"].ToString());
}
if (ds.Tables[0].Rows[0]["m_ConfigInfoID"].ToString() != "")
{
model.m_ConfigInfoID = int.Parse(ds.Tables[0].Rows[0]["m_ConfigInfoID"].ToString());
}
model.mName = ds.Tables[0].Rows[0]["mName"].ToString();
model.mPIC = ds.Tables[0].Rows[0]["mPIC"].ToString();
model.mWidth = ds.Tables[0].Rows[0]["mWidth"].ToString();
model.mHeight = ds.Tables[0].Rows[0]["mHeight"].ToString();
model.mExpName = ds.Tables[0].Rows[0]["mExpName"].ToString();
model.mData = ds.Tables[0].Rows[0]["mData"].ToString();
if (ds.Tables[0].Rows[0]["mAppendTime"].ToString() != "")
{
model.mAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["mAppendTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddM_ExpressTemplatesInfo(M_ExpressTemplatesInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_M_ExpressTemplatesInfo(");
strSql.Append("mName,mPIC,mWidth,mHeight,mExpName,mData,mAppendTime,m_ConfigInfoID)");
strSql.Append(" values (");
strSql.Append("@mName,@mPIC,@mWidth,@mHeight,@mExpName,@mData,@mAppendTime,@m_ConfigInfoID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@mName", SqlDbType.VarChar, 50),
new SqlParameter("@mPIC", SqlDbType.VarChar, 50),
new SqlParameter("@mWidth", SqlDbType.VarChar, 50),
new SqlParameter("@mHeight", SqlDbType.VarChar, 50),
new SqlParameter("@mExpName", SqlDbType.VarChar, 128),
new SqlParameter("@mData", SqlDbType.NText),
new SqlParameter("@mAppendTime", SqlDbType.DateTime),
new SqlParameter("@m_ConfigInfoID", SqlDbType.Int, 4),
};
parameters[0].Value = model.mName;
parameters[1].Value = model.mPIC;
parameters[2].Value = model.mWidth;
parameters[3].Value = model.mHeight;
parameters[4].Value = model.mExpName;
parameters[5].Value = model.mData;
parameters[6].Value = model.mAppendTime;
parameters[7].Value = model.m_ConfigInfoID;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Order_Print_Item = 10; //打印分页，每页条数
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-1-1-8") || CheckUserPopedoms("3-1-2-8") || CheckUserPopedoms("3-2-1-8") || CheckUserPopedoms("3-2-2-8") || CheckUserPopedoms("3-2-3-8") || CheckUserPopedoms("3-2-4-8") || CheckUserPopedoms("3-2-5-8") || CheckUserPopedoms("3-3-1-8") || CheckUserPopedoms("3-3-2-8") || CheckUserPopedoms("3-3-3-8"))
{
act = HTTPRequest.GetString("act");
orderid = HTTPRequest.GetInt("orderid", 0);
ordertype = HTTPRequest.GetInt("ordertype", 0);
ot = HTTPRequest.GetString("ot");
Order_Print_Item = this.config.Order_Print_Item;
if (act == "pl")//批量打印
{
orderidstr = HTTPRequest.GetString("orderid");
ordertypestr = HTTPRequest.GetString("ordertype");
string[] orderid_array = Utils.SplitString(orderidstr, "x");
string[] ordertypestr_array = Utils.SplitString(ordertypestr, "x");
}
if (orderid > 0)
{
oi = Orders.GetOrderInfoModel(orderid);
if (oi != null)
{
string tSteps = ((oi.oSteps == 1) ? " tbOrderListInfo.oWorkType=0 " : " tbOrderListInfo.oWorkType<>0 ").ToString();
string tSteps_b = ((oi.oSteps == 1) ? " IsVerify=0 " : " IsVerify<>0 ").ToString();
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-1-1-9") || CheckUserPopedoms("3-1-2-9") || CheckUserPopedoms("3-2-1-9") || CheckUserPopedoms("3-2-2-9") || CheckUserPopedoms("3-2-3-9") || CheckUserPopedoms("3-2-4-9") || CheckUserPopedoms("3-2-5-9") || CheckUserPopedoms("3-3-1-9") || CheckUserPopedoms("3-3-2-9") || CheckUserPopedoms("3-3-3-9"))
{
ShowMoney = true;
ShowMoney = (HTTPRequest.GetString("ShowMoney").Trim() != "") ? false : true;
}
else
{
ShowMoney = false;
}
Print_Foot = Utils.ReplaceString(this.config.Print_Foot, "[", "<", false);
Print_Foot = Utils.ReplaceString(Print_Foot, "]", ">", false);
OrderList = Orders.GetOrderListInfoList(" OrderID=" + oi.OrderID + " and " + tSteps + " order by OrderListID asc").Tables[0];
OrderFieldList = Orders.GetOrderFieldInfoList(" OrderType=" + ordertype + " and fState=0 and fPrint=0").Tables[0];
if (OrderFieldList != null)
{
OrderFieldValueList = Orders.GetOrderFieldValueInfoList(" OrderListID in(select tbOrderListInfo.OrderListID from tbOrderListInfo where tbOrderListInfo.OrderID=" + oi.OrderID + " and " + tSteps + ") and " + tSteps_b + "").Tables[0];
}
foreach (DataRow dr in OrderList.Rows)
{
summoney += Convert.ToDecimal(dr["oQuantity"]) * Convert.ToDecimal(dr["oPrice"]);
}
summoney_str = chang(summoney.ToString());
summoney = Math.Round(summoney, config.MoneyDecimal);
//库存调拨单,整理数据
if (oi.oType == 9)
{
DataTable nOrderList = new DataTable();
nOrderList = OrderList.Clone();
foreach (DataRow dr in OrderList.Rows)
{
if (Convert.ToDecimal(dr["oQuantity"].ToString()) < 0)
{
dr["StorageName"] = "来源:" + dr["StorageName"].ToString();
nOrderList.Rows.Add(dr.ItemArray);
}
}
nOrderList.AcceptChanges();
foreach (DataRow dr in OrderList.Rows)
{
foreach (DataRow ddr in nOrderList.Rows)
{
if (Convert.ToInt32(ddr["ProductsID"].ToString()) == Convert.ToInt32(dr["ProductsID"].ToString()))
{
if (Convert.ToDecimal(dr["oQuantity"].ToString()) > 0)
{
ddr["oQuantity"] = Convert.ToDecimal(dr["oQuantity"].ToString());
ddr["StorageName"] = ddr["StorageName"].ToString() + "<br>去向:" + dr["StorageName"].ToString() + "";
}
}
/*
* else
* {
*
* if (Convert.ToInt32(dr["oQuantity"].ToString()) > 0)
* {
* dr["StorageName"] = "去向:" + dr["StorageName"].ToString() + "<br>";
* }
* else
* {
* dr["oQuantity"] = -1 * Convert.ToInt32(dr["oQuantity"].ToString());
* dr["StorageName"] = "来源:" + dr["StorageName"].ToString() + "<br>";
* }
*
* nOrderList.Rows.Add(dr);
*
* }*/
}
nOrderList.AcceptChanges();
}
OrderList.Clear();
OrderList = nOrderList.Copy();
}
//处理分页打印
if (OrderList.Rows.Count > 0)
{
print_page_sum = (int)Math.Ceiling((float)OrderList.Rows.Count / (float)Order_Print_Item);
for (int k = 0; k < print_page_sum; k++)
{
DataTable _dt = new DataTable();
_dt = OrderList.Clone();
_dt = Public.PublicLib.GetPagedTable(OrderList, k + 1, Order_Print_Item);
_dt.TableName = (k + 1).ToString();
OrderListSet.Tables.Add(_dt);
OrderListSet.AcceptChanges();
}
}
//制单人
print_ui = tbUserInfo.GetUserInfoModel(oi.UserID);
//审核人
OrderWorkingLogInfo owil = Orders.GetOrderWorkingUserID(oi.OrderID, 2);
if (owil != null)
{
print_v_ui = tbUserInfo.GetUserInfoModel(owil.UserID);
}
else
{
print_v_ui = null;
}
//是否为网购订单
_ms = M_Utils.GetM_SendGoodsInfoModelByOrderID(oi.OrderID);
if (_ms != null)
{
IsMOrder = true;
_mxsp = M_Utils.GetM_ExpressTemplatesInfoModel(_ms.mExpName);
//转换交易单号
oi.oCustomersOrderID = "";
string _m_TradeInfoID = _ms.m_TradeInfoID;
string[] _m_TradeInfoIDArr = Utils.SplitString(_m_TradeInfoID, ",");
foreach (string _m_TradeInfoID_Str in _m_TradeInfoIDArr)
{
if (_m_TradeInfoID_Str.Trim() != "")
{
M_TradeInfo _mt = new M_TradeInfo();
try
{
try
{
_mt = M_Utils.GetM_TradeInfoModel(Convert.ToInt32(_m_TradeInfoID_Str.Trim()));
if (_mt != null)
{
BuyerName = _mt.buyer_nick;
oi.oCustomersOrderID += _mt.tid.ToString() + " ";
}
}
catch
{
}
}
finally
{
_mt = null;
}
}
}
}
else
{
IsMOrder = false;
_mxsp = null;
}
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 6;
owl.oMsg = (ot.Trim() != "d")?"":"打印订单,备货";
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
}
else
{
AddErrLine("参数错误,单据不存在!");
}
}
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-6"))
{
string mName = Utils.ChkSQL(HTTPRequest.GetString("mName"));
string mPIC = Utils.ChkSQL(HTTPRequest.GetString("mPIC"));
string mWidth = Utils.ChkSQL(HTTPRequest.GetString("mWidth"));
string mHeight = Utils.ChkSQL(HTTPRequest.GetString("mHeight"));
string mExpName = Utils.ChkSQL(HTTPRequest.GetString("mExpName"));
string mData = Utils.ChkSQL(HTTPRequest.GetString("mData"));
Act = HTTPRequest.GetString("Act");
m_ExpressTemplatesID = HTTPRequest.GetInt("m_ExpressTemplatesID", 0);
if (Act == "Edit")
{
ExpressTemplates = M_Utils.GetM_ExpressTemplatesInfoModel(m_ExpressTemplatesID);
if (ExpressTemplates != null)
{
if (ExpressTemplates.m_ConfigInfoID != M_Config.m_ConfigInfoID)
{
AddErrLine("参数错误,该模板非本网店!");
}
}
else
{
AddErrLine("参数错误,系统中没有该模板!");
}
}
if (ispost)
{
ExpressTemplates.mPIC = mPIC;
ExpressTemplates.mWidth = mWidth;
ExpressTemplates.mHeight = mHeight;
ExpressTemplates.mExpName = mExpName;
ExpressTemplates.mData = mData;
if (Act == "Add")
{
if (!M_Utils.ExistsM_ExpressTemplatesInfo(mName))
{
ExpressTemplates.m_ConfigInfoID = M_Config.m_ConfigInfoID;
ExpressTemplates.mAppendTime = DateTime.Now;
ExpressTemplates.mName = mName;
if (M_Utils.AddM_ExpressTemplatesInfo(ExpressTemplates) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("名称:" + mName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
if (Act == "Edit")
{
if (m_ExpressTemplatesID > 0)
{
if (!M_Utils.ExistsM_ExpressTemplatesInfo(mName) || mName == ExpressTemplates.mName)
{
ExpressTemplates.mName = mName;
try
{
M_Utils.UpdateM_ExpressTemplatesInfo(ExpressTemplates);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("名称:" + mName + ",已存在,请更换!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
else
{
AddErrLine("参数错误,修改失败!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
if (Act == "Del")
{
try
{
M_Utils.DeleteM_ExpressTemplatesInfoList(HTTPRequest.GetString("etId"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
PublicExpressTemplatesJson = M_Utils.GetPublicExpressTemplatesJson();
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
public M_ExpressTemplatesInfo m_exp = new M_ExpressTemplatesInfo(); //网购运单
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("8-3-2-3"))
{
int oid = HTTPRequest.GetInt("oid", 0);//发货单系统编号
if (oid > 0)
{
oi = Orders.GetOrderInfoModel(oid);
if (oi != null)
{
m_sg = M_Utils.GetM_SendGoodsInfoModelByOrderID(oid);
if (m_sg != null)
{
m_exp = M_Utils.GetM_ExpressTemplatesInfoModel(m_sg.mExpName);
if (m_exp != null)
{
OrderID = oi.oOrderNum;
string MTradeInfoID = m_sg.m_TradeInfoID;
string[] _m_TradeInfoIDArr = Utils.SplitString(MTradeInfoID, ",");
MTradeInfoID = "";
foreach (string _m_TradeInfoID_Str in _m_TradeInfoIDArr)
{
if (_m_TradeInfoID_Str.Trim() != "")
{
M_TradeInfo _mt = new M_TradeInfo();
try
{
try
{
_mt = M_Utils.GetM_TradeInfoModel(Convert.ToInt32(_m_TradeInfoID_Str.Trim()));
if (_mt != null)
{
BuyerName = _mt.buyer_nick;
MTradeInfoID += _mt.tid.ToString() + " ";
}
}
catch
{
}
}
finally
{
_mt = null;
}
}
}
Receiver_name = m_sg.receiver_name;
Receiver_state = m_sg.receiver_state;
Receiver_city = m_sg.receiver_city;
Receiver_district = m_sg.receiver_district;
Receiver_address = m_sg.receiver_address;
Receiver_zip = m_sg.receiver_zip;
Receiver_mobile = m_sg.receiver_mobile;
Receiver_phone = m_sg.receiver_phone;
From_name = m_sg.from_name;
From_company = M_Config.StoresName;
From_state = m_sg.from_state;
From_city = m_sg.from_city;
From_district = m_sg.from_district;
From_address = m_sg.from_address;
From_zip = m_sg.from_zip;
From_mobile = m_sg.from_mobile;
From_phone = m_sg.from_phone;
MMemo = m_sg.mMemo;
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{OrderID}", OrderID, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{MTradeInfoID}", MTradeInfoID, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{BuyerName}", BuyerName, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_name}", Receiver_name, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_state}", Receiver_state, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_city}", Receiver_city, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_district}", Receiver_district, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_address}", Receiver_address, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_zip}", Receiver_zip, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_mobile}", Receiver_mobile, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{Receiver_phone}", Receiver_phone, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_name}", From_name, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_company}", From_company, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_state}", From_state, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_city}", From_city, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_district}", From_district, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_address}", From_address, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_zip}", From_zip, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_mobile}", From_mobile, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{From_phone}", From_phone, false);
m_exp.mData = Utils.ReplaceString(m_exp.mData, "{MMemo}", MMemo, false);
}
else
{
AddErrLine("网购单不存在!");
}
}
else
{
AddErrLine("网购运单模板不存在!");
}
}
else
{
AddErrLine("该发货单不存在!");
}
}
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()));
}
}
public string BuyerName = ""; //买家昵称
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("3-1-1-8") || CheckUserPopedoms("3-1-2-8") || CheckUserPopedoms("3-2-1-8") || CheckUserPopedoms("3-2-2-8") || CheckUserPopedoms("3-2-3-8") || CheckUserPopedoms("3-2-4-8") || CheckUserPopedoms("3-2-5-8") || CheckUserPopedoms("3-3-1-8") || CheckUserPopedoms("3-3-2-8") || CheckUserPopedoms("3-3-3-8"))
{
orderid = HTTPRequest.GetInt("orderid", 0);
ordertype = HTTPRequest.GetInt("ordertype", 0);
if (orderid > 0)
{
oi = Orders.GetOrderInfoModel(orderid);
if (oi != null)
{
string tSteps = ((oi.oSteps == 1) ? " tbOrderListInfo.oWorkType=0 " : " tbOrderListInfo.oWorkType<>0 ").ToString();
OrderList = Orders.GetOrderListInfoList(" OrderID=" + oi.OrderID + " and " + tSteps + " order by OrderListID asc").Tables[0];
//取已收发列表
StorageOrderList = tbStorageProductLogInfo.GetStorageProductLogListINOrderList(oi.OrderID).Tables[0];
//库存调拨单,整理数据
if (oi.oType == 9)
{
DataTable nOrderList = new DataTable();
nOrderList = OrderList.Clone();
foreach (DataRow dr in OrderList.Rows)
{
if (Convert.ToDecimal(dr["oQuantity"].ToString()) < 0)
{
dr["StorageName"] = "来源:" + dr["StorageName"].ToString();
nOrderList.Rows.Add(dr.ItemArray);
}
}
nOrderList.AcceptChanges();
foreach (DataRow dr in OrderList.Rows)
{
foreach (DataRow ddr in nOrderList.Rows)
{
if (Convert.ToInt32(ddr["ProductsID"].ToString()) == Convert.ToInt32(dr["ProductsID"].ToString()))
{
if (Convert.ToDecimal(dr["oQuantity"].ToString()) > 0)
{
ddr["oQuantity"] = Convert.ToDecimal(dr["oQuantity"].ToString());
ddr["StorageName"] = ddr["StorageName"].ToString() + "<br>去向:" + dr["StorageName"].ToString() + "";
}
}
}
nOrderList.AcceptChanges();
}
OrderList.Clear();
OrderList = nOrderList.Copy();
}
//制单人
print_ui = tbUserInfo.GetUserInfoModel(oi.UserID);
//审核人
OrderWorkingLogInfo owil = Orders.GetOrderWorkingUserID(oi.OrderID, 2);
if (owil != null)
{
print_v_ui = tbUserInfo.GetUserInfoModel(owil.UserID);
}
else
{
print_v_ui = null;
}
//是否为网购订单
_ms = M_Utils.GetM_SendGoodsInfoModelByOrderID(oi.OrderID);
if (_ms != null)
{
IsMOrder = true;
_mxsp = M_Utils.GetM_ExpressTemplatesInfoModel(_ms.mExpName);
//转换交易单号
oi.oCustomersOrderID = "";
string _m_TradeInfoID = _ms.m_TradeInfoID;
string[] _m_TradeInfoIDArr = Utils.SplitString(_m_TradeInfoID, ",");
foreach (string _m_TradeInfoID_Str in _m_TradeInfoIDArr)
{
if (_m_TradeInfoID_Str.Trim() != "")
{
M_TradeInfo _mt = new M_TradeInfo();
try
{
try
{
_mt = M_Utils.GetM_TradeInfoModel(Convert.ToInt32(_m_TradeInfoID_Str.Trim()));
if (_mt != null)
{
BuyerName = _mt.buyer_nick;
oi.oCustomersOrderID += _mt.tid.ToString() + " ";
}
}
catch
{
}
}
finally
{
_mt = null;
}
}
}
}
else
{
IsMOrder = false;
_mxsp = null;
}
OrderWorkingLogInfo owl = new OrderWorkingLogInfo();
owl.OrderID = oi.OrderID;
owl.UserID = this.userid;
owl.oType = 6;
owl.oMsg = "打印单据,仓库收发货";
owl.pAppendTime = DateTime.Now;
Orders.AddOrderWorkingLogInfo(owl);
}
else
{
AddErrLine("参数错误,单据不存在!");
}
}
else
{
AddErrLine("参数错误!");
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
