protected void bindGrid(string goodNo)
{
try
{
if (goodNo == "ALL")
{
goodNo = "%";
}
DataTable dt = new DataTable();
string sqlCmd = "select * from [goodsList] where [goodsNo] like '" + goodNo + "' order by goodsno";
SqlSel_Pro.GetSqlSel(ref dt, sqlCmd);
Grid1.DataSource = dt;
Grid1.DataBind();
sqlCmd = "select max(id) from goodsList";
string curMaxId = SqlSel_Pro.GetSqlScale(sqlCmd).ToString();
if (string.IsNullOrEmpty(curMaxId))
{
label_hidden.Text = "0";
}
else
{
label_hidden.Text = curMaxId;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
protected void btn_rePush_Click(object sender, EventArgs e)
{
try
{
//是否存在非异常单
CheckBoxField field1 = (CheckBoxField)Grid1.FindColumn("CheckBoxField1");
string sqlCmd = string.Empty;
foreach (GridRow row in Grid1.Rows)
{
int rowIndex = row.RowIndex;
bool isSel = field1.GetCheckedState(rowIndex);
if (isSel)
{
string apiState = row.Values[7].ToString();//API状态
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
if (apiState != "异常")
{
continue;
}
else
{
sqlCmd = "update sfyordertab set isnew='0' where SOId='" + rowID + "'";
SqlSel_Pro.ExeSql(sqlCmd);
}
}
}
Alert.Show("操作成功！");
reBound();
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string userName = tbxUserName.Text.Trim();
string password = tbxPassword.Text.Trim();
string psw = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5");
//
DataTable dt = new DataTable();
string sqlCmd = "select * from T_UserList where userId='" + userName + "' and userPsw='" + psw + "'";
SqlSel_Pro.GetSqlSel(ref dt, sqlCmd);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["enabled"].ToString() == "0")
{
Alert.ShowInTop("用户未启用，请联系管理员！");
return;
}
Session["loginUser"] = userName;
Response.Redirect("main.aspx");
}
else
{
Alert.ShowInTop("用户名或密码错误！");
return;
}
}
//服务器端删除
protected void deleteFromDb(int DbId)
{
string sqlCmd = "delete from goodsList where id=" + DbId;
SqlSel_Pro.ExeSql(sqlCmd);
bindGrid("ALL");
}
protected void btn1_Click(object sender, EventArgs e)
{
string sqlCmdStr = "select parentid from SFYOrderTab where OrderId='" + txb1.Text + "'";
string orgId = SqlSel_Pro.GetSqlScale(sqlCmdStr).ToString();
TextBox1.Text = orgId;
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string sqlCmd = "";
// 修改的现有数据
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
sqlCmd = "update [SFYOrderTab] set CONTACT_NAME='" + Grid1.Rows[rowIndex].Values[4].ToString() + "',";
sqlCmd += "PHONE_NUMBER='" + Grid1.Rows[rowIndex].Values[5].ToString() + "',ADDRESS='" + Grid1.Rows[rowIndex].Values[6].ToString() + "'";
sqlCmd += " where [SOId]=" + rowID;
SqlSel_Pro.ExeSql(sqlCmd);
}
Alert.Show("已保存");
//刷新结果集
//tgb_PO_TriggerClick(sender, e);
reBound();
}
catch (Exception ex)
{
Alert.Show(ex.ToString());
return;
}
}
protected void menuTreeBind(string userId)
{
if (userId != null || userId != "")
{
string sqlCmd = "select * from t_sysMenu where id in( ";
sqlCmd += "select menuId from t_rolemenu where roleid in ( ";
sqlCmd += "select roleid from t_userrole where userid=( ";
sqlCmd += "select id from t_userlist where userid='" + userId + "')) group by menuId) order by sortIndex";
DataTable treeDt = new DataTable();
SqlSel_Pro.GetSqlSel(ref treeDt, sqlCmd);
DataSet ds = new DataSet();
ds.Tables.Add(treeDt);
ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["Id"], ds.Tables[0].Columns["ParentMenuId"], false);
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row.IsNull("ParentMenuId"))
{
TreeNode node = new TreeNode();
node.Text = row["Title"].ToString();
node.NodeID = row["id"].ToString();
//node.NavigateUrl = ResolveUrl(row["NavigateUrl"].ToString());
tree_menu.Nodes.Add(node);
ResolveSubTree(row, node);
}
}
tree_menu.Nodes[0].Expanded = true;
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string curUser = GetUser();
string sqlCmd = "";
// 修改的现有数据
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
if (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString()))
{
Alert.ShowInTop("商品编码不可为空！");
return;
}
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
sqlCmd = "update goodsList set goodsNo='" + Grid1.Rows[rowIndex].Values[0].ToString() + "',";
sqlCmd += "[goodsName]='" + Grid1.Rows[rowIndex].Values[1].ToString() + "',";
sqlCmd += "[specification]='" + Grid1.Rows[rowIndex].Values[2].ToString().Trim() + "',";
sqlCmd += "enabled='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) + "',";
sqlCmd += "[createDte]='" + DateTime.Now + "',[createUser]='" + curUser + "' ";
sqlCmd += "where id=" + rowID;
SqlSel_Pro.ExeSql(sqlCmd);
}
// 新增数据
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
for (int i = 0; i < newAddedList.Count; i++)
{
//DataRow rowData = CreateNewData(table, newAddedList[i]);
//table.Rows.Add(rowData);
if (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString()))
{
Alert.ShowInTop("商品编码不可为空！");
return;
}
sqlCmd = "insert into goodsList (goodsNo,goodsName,specification,enabled,createDte,createUser) values ";
sqlCmd += "('" + newAddedList[i]["goodsNo"].ToString().Trim() + "','" + newAddedList[i]["goodsName"].ToString() + "','" + newAddedList[i]["specification"].ToString().Trim() + "',";
sqlCmd += "'" + Convert.ToBoolean(newAddedList[i]["enabled"]) + "','" + DateTime.Now + "','" + curUser + "')";
SqlSel_Pro.ExeSql(sqlCmd);
}
//表格数据重新绑定
bindGrid("ALL");
Alert.Show("保存成功！");
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
protected void tree_menu_NodeCommand1(object sender, TreeCommandEventArgs e)
{
DataTable menuDt = new DataTable();
int menuId = Convert.ToInt32(e.NodeID);
string sqlCmd = "select * from t_sysMenu where id=" + menuId;
SqlSel_Pro.GetSqlSel(ref menuDt, sqlCmd);
string NavigateUrl = menuDt.Rows[0]["NavigateUrl"].ToString();
string tabName = menuDt.Rows[0]["Title"].ToString();
PageContext.RegisterStartupScript(mainTabStrip.GetAddTabReference("dynamic_tab" + menuId.ToString(), ResolveUrl(NavigateUrl), tabName, IconHelper.GetIconUrl(Icon.ApplicationAdd), true));
}
//获取商品Id
protected int getGoodIdByNo(string goodsNo)
{
try
{
int goodId = 0;
string sqlCmd = "select id from goodsList where goodsNo='" + goodsNo + "'";
goodId = Convert.ToInt32(SqlSel_Pro.GetSqlScale(sqlCmd));
return(goodId);
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return(0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["loginUser"] == null)
{
Response.Redirect("default.aspx");
}
else
{
string userId = GetUser();
menuTreeBind(userId);
string sqlCmd = "select userName from t_userlist where userid='" + userId + "' ";
string curUser = SqlSel_Pro.GetSqlScale(sqlCmd).ToString();
l_loginInfo.Text = curUser + "，欢迎登陆.";
}
}
}
//加载数据
protected void bindGrid(string loadField)
{
try
{
DataTable dt = new DataTable();
string sqlCmd = "";
if (loadField == "ALL")//加载全部
{
sqlCmd = "select (select goodsNo from goodsList where goodsList.id=SaleAct.origGoodsId) as goodsNo,";
sqlCmd += "(select goodsNo from goodsList where goodsList.id=SaleAct.giftGoodsId) as giftNo,";
sqlCmd += "CONVERT(varchar(100), startDte, 23) as dstartDte,";
sqlCmd += "CONVERT(varchar(100), endDte, 23) as dendDte,";
sqlCmd += " * from SaleAct order by giftGoodsId";
}
else //根据编码查询
{
sqlCmd = "select * from (select (select goodsNo from goodsList where goodsList.id=SaleAct.origGoodsId) as goodsNo,";
sqlCmd += "(select goodsNo from goodsList where goodsList.id=SaleAct.giftGoodsId) as giftNo,";
sqlCmd += "CONVERT(varchar(100), startDte, 23) as dstartDte,";
sqlCmd += "CONVERT(varchar(100), endDte, 23) as dendDte,";
sqlCmd += " * from SaleAct) A where A.goodsNo='" + loadField + "'";
}
SqlSel_Pro.GetSqlSel(ref dt, sqlCmd);
Grid1.DataSource = dt;
Grid1.DataBind();
//取当前最大数据id
sqlCmd = "select max(id) from SaleAct";
string curMaxId = SqlSel_Pro.GetSqlScale(sqlCmd).ToString();
if (string.IsNullOrEmpty(curMaxId))
{
label_hidden.Text = "0";
}
else
{
label_hidden.Text = curMaxId;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string sqlCmd = "";
// 修改的现有数据
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
if (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString()) || string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[2].ToString()))
{
Alert.ShowInTop("商品编码或索菲亚编码不可为空！");
return;
}
if (Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) == true & Convert.ToInt32(Grid1.Rows[rowIndex].Values[4]) == 0)
{
Alert.ShowInTop("不为最小单位的商品请添加计量数量!");
return;
}
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
sqlCmd = "update t_MapGoodsList set goodsNo='" + Grid1.Rows[rowIndex].Values[0].ToString() + "',";
sqlCmd += "goodsSpec='" + Grid1.Rows[rowIndex].Values[1].ToString() + "',";
sqlCmd += "targetNo='" + Grid1.Rows[rowIndex].Values[2].ToString().Trim() + "',";
sqlCmd += "isMinUnitOrNo='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) + "',";
sqlCmd += "UnitTimes=" + Convert.ToInt32(Grid1.Rows[rowIndex].Values[4]) + ",isOrder='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[5]) + "' ";
sqlCmd += "where id=" + rowID;
SqlSel_Pro.ExeSql(sqlCmd);
}
// 新增数据
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
DataTable table = createDataTable();
for (int i = 0; i < newAddedList.Count; i++)
{
//DataRow rowData = CreateNewData(table, newAddedList[i]);
//table.Rows.Add(rowData);
if (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString()) || string.IsNullOrEmpty(newAddedList[i]["targetNo"].ToString()))
{
Alert.ShowInTop("商品编码或索菲亚编码不可为空！");
return;
}
if (Convert.ToBoolean(newAddedList[i]["isMinUnitOrNo"]) == true & Convert.ToInt32(newAddedList[i]["UnitTimes"]) == 0)
{
Alert.ShowInTop("不为最小单位的商品请添加计量数量!");
return;
}
sqlCmd = "insert into t_MapGoodsList (goodsNo,goodsSpec,targetNo,isMinUnitOrNo,UnitTimes,isOrder) values ";
sqlCmd += "('" + newAddedList[i]["goodsNo"].ToString().Trim() + "','" + newAddedList[i]["goodsSpec"].ToString() + "','" + newAddedList[i]["targetNo"].ToString().Trim() + "',";
sqlCmd += "'" + Convert.ToBoolean(newAddedList[i]["isMinUnitOrNo"]) + "'," + Convert.ToInt32(newAddedList[i]["UnitTimes"]) + ",'" + Convert.ToBoolean(newAddedList[i]["isOrder"]) + "')";
SqlSel_Pro.ExeSql(sqlCmd);
}
//表格数据重新绑定
bindGrid("ALL");
Alert.Show("保存成功！");
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
public string wdgj_TradeList(string ShopId, string tradeDate)
{
//获取已发货送货单信息
string shortDate = Convert.ToDateTime(tradeDate).ToShortDateString();
string sqlCmd = "select TradeId,TradeTime,TradeNo,SndTo,NickName,t1.Tel,t1.Adr,t1.GoodsTotal,CustomerRemark,t1.warehouseId,";
sqlCmd += "t1.PostId,t1.SndTime,t1.AllTotal,t1.Postage,TradeFrom,TradeStatus,t3.Name AS LogisticName,tradeNo2,t1.Remark";
sqlCmd += " from g_trade_tradeList t1 left join g_customer_customerlist t2 ";
sqlCmd += " on t1.customerId=t2.customerId left join G_Cfg_LogisticList t3 on t1.LogisticID=t3.LogisticID";
sqlCmd += " where t1.shopId='" + ShopId + "' and Convert(nvarchar(50),sndTime,23)='" + tradeDate + "' and tradeStatus='11'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
DataRow dr = dt.Rows[i];
//精简联系人信息
if (dr["SndTo"].ToString().Contains(" ") & dr["SndTo"].ToString().Contains("*"))
{
string sndTo = dr["SndTo"].ToString();
dr["SndTo"] = sndTo.Substring(0, sndTo.IndexOf(" "));
}
if (ShopId == "1029")
{
//排除非新业务店铺的这两个仓库的订单
if (dr["warehouseId"].ToString() != "1027" && dr["warehouseId"].ToString() != "1039")
{
dt.Rows.Remove(dr);
}
}
}
//foreach (DataRow dr in dt.Rows)
//{
// if (ShopId == "1029")
// {
// //排除非新业务店铺的这两个仓库的订单
// if (dr["warehouseId"].ToString() != "1027" && dr["warehouseId"].ToString() != "1039")
// {
// dt.Rows.Remove(dr);
// }
// }
//}
WdgjOrders WdgjOrder = new WdgjOrders
{
ShopId = ShopId,
GetDate = Convert.ToDateTime(tradeDate)
};
List <OrderInfo> orders = new List <OrderInfo>();
foreach (DataRow dr in dt.Rows)
{
string tradeId = dr["TradeId"].ToString();
string origOrderNo = dr["tradeNo2"].ToString();
OrderInfo orderInfo = new OrderInfo
{
OrderId = tradeId,
TradeTime = Convert.ToDateTime(dr["TradeTime"]),
OrderNo = dr["TradeNo"].ToString(),
CustomerNo = dr["NickName"].ToString(),
Adr = dr["Adr"].ToString(),
ContactName = dr["SndTo"].ToString(),
ContactPhone = dr["Tel"].ToString(),
SendTime = Convert.ToDateTime(dr["SndTime"]),
LogisticName = dr["LogisticName"].ToString(),
PostId = dr["PostId"].ToString(),
NeedDate = Convert.ToDateTime(dr["SndTime"]),
WarehouseId = dr["warehouseId"].ToString()
};
//新业务部订单
if (ShopId == "1029")
{
//非手工单获取大客户编码
if (dr["TradeFrom"].ToString() == "蜘蛛")
{
DataTable tempDt = new DataTable();
sqlCmd = "select * from view_sfyorders where cust_po_num='" + dr["NickName"].ToString() + "'";
if (SqlSel_Pro.GetSqlSel(ref tempDt, sqlCmd))
{
orderInfo.CustomerNo = tempDt.Rows[0]["ouNO"].ToString();
orderInfo.ContactName = dr["SndTo"].ToString() + "/" + dr["NickName"].ToString();//客户姓名+PO号
}
else
{
orderInfo.CustomerNo = null;
}
}
}
//添加商品明细
List <Goods> goodsList = new List <Goods>();
DataTable goodsTable = new DataTable();
sqlCmd = "select a.*,b.goodsNo from g_trade_goodsList a left join G_Goods_GoodsList b"
+ " on a.goodsid = b.goodsid where tradeId = '" + tradeId + "'";
SqlSel.GetSqlSel(ref goodsTable, sqlCmd);
foreach (DataRow item in goodsTable.Rows)
{
string goodsNo = item["goodsNo"].ToString();
Goods goods = new Goods
{
GoodsNo = goodsNo,
Descriptions = item["TradeSpec"].ToString(),//定制规格
SellCount = Convert.ToInt32(item["SellCount"]),
SellPrice = Convert.ToDouble(item["SellPrice"]),
IsOrder = string.IsNullOrEmpty(item["TradeSpec"].ToString()) ? false : true,
IsGift = Convert.ToDouble(item["SellPrice"]) > 0 ? false : true
};
if (ShopId == "1029" & dr["TradeFrom"].ToString() == "蜘蛛")
{
if (goods.Descriptions.Contains("*"))
{
string sizeInfo = goods.Descriptions;
string productLength = "", productWidth = "", productHeight = "";
productLength = sizeInfo.Substring(0, sizeInfo.IndexOf("*")); //长
productWidth = sizeInfo.Substring(sizeInfo.IndexOf("*") + 1, sizeInfo.LastIndexOf("*") - sizeInfo.IndexOf("*") - 1); //宽
productHeight = sizeInfo.Substring(sizeInfo.LastIndexOf("*") + 1); //厚
decimal lastLenth = Convert.ToDecimal(productLength) / 10; //以厘米为单位
decimal lastWidth = Convert.ToDecimal(productWidth) / 10;
decimal lastHeight = Convert.ToDecimal(productHeight) / 10;
goods.Descriptions = lastLenth + "*" + lastWidth + "*" + lastHeight;
}
//string[] orderArr = origOrderNo.Split(',');
//System.Text.StringBuilder builder = new System.Text.StringBuilder();
//foreach (string order in orderArr)
//{
// builder.AppendFormat("'{0},'", order);
//}
//string orderListStr = builder.ToString().TrimEnd(',');
//sqlCmd = "select * from sfyordertab where orderId in (" + orderListStr + ")";
//DataTable sfyOrigOrders = new DataTable();
//SqlSel_Pro.GetSqlSel(ref sfyOrigOrders, sqlCmd);
//if (dr["Remark"].ToString().Contains("索菲亚定制"))
//{
// goods.IsOrder = true;
// goods.IsGift = false;
//}
//else
//{
// goods.IsOrder = false;
// goods.IsGift = false;
//}
//判断是否赠品
goods.IsGift = Convert.ToDouble(item["SellPrice"]) > 0 ? true : false;//接口赠品价格大于0为标识
}
goodsList.Add(goods);
}
orderInfo.GoodsList = goodsList;
orders.Add(orderInfo);
}
WdgjOrder.Orders = orders;
//dt.Columns.Add("NeedDate");
//dt.Columns.Add("Items");
////索菲亚订单提取需求日期（交期）
//if (ShopId == "1029")
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// string CustomerRemark = dt.Rows[i]["CustomerRemark"].ToString();
// string sndTo = dt.Rows[i]["SndTo"].ToString().Replace(" ", "");//去除空格
// if (dt.Rows[i]["TradeFrom"].ToString() == "蜘蛛")
// {
// dt.Rows[i]["NeedDate"] = CustomerRemark.Substring(CustomerRemark.LastIndexOf("：") + 1);//需求日期
// }
// if (sndTo.Contains("规格"))
// {
// dt.Rows[i]["SndTo"] = sndTo.Substring(0, sndTo.IndexOf("规"));//联系人去除部分定制规格信息
// }
// else
// {
// dt.Rows[i]["SndTo"] = sndTo;
// }
// }
//}
////添加商品明细
//string curTradeId = "";
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// curTradeId = dt.Rows[i]["TradeId"].ToString();
// dt.Rows[i]["Items"] = wdgj_TradeItems(curTradeId);
//}
//string tradeInfo = string.Empty;
//tradeInfo = JsonConvert.SerializeObject(dt);
//return tradeInfo;
//dt.TableName = "tradeInfo";
//return dt;
return(JsonConvert.SerializeObject(WdgjOrder));
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string sqlCmd = "";
int origGoodsId = 0, giftGoodsId = 0;
// 修改的现有数据
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
if (Convert.ToBoolean(Grid1.Rows[rowIndex].Values[2]) == true & (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString()) || string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[2].ToString())))
{
Alert.ShowInTop("商品编码或赠品编码不可为空！");
return;
}
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
origGoodsId = getGoodIdByNo(Grid1.Rows[rowIndex].Values[0].ToString().Trim());
giftGoodsId = getGoodIdByNo(Grid1.Rows[rowIndex].Values[1].ToString().Trim());
if (origGoodsId == 0 || giftGoodsId == 0)
{
Alert.ShowInTop("商品编码不存在，请校验！");
return;
}
sqlCmd = "update SaleAct set origGoodsId=" + origGoodsId + ",";
sqlCmd += "giftGoodsId=" + giftGoodsId + ",";
sqlCmd += "enabled='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[2]) + "',";
sqlCmd += "startDte='" + Convert.ToDateTime(Grid1.Rows[rowIndex].Values[3]) + "',";
sqlCmd += "endDte='" + Convert.ToDateTime(Grid1.Rows[rowIndex].Values[4]) + "' ";
sqlCmd += "where id=" + rowID;
SqlSel_Pro.ExeSql(sqlCmd);
}
// 新增数据
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
for (int i = 0; i < newAddedList.Count; i++)
{
//DataRow rowData = CreateNewData(table, newAddedList[i]);
//table.Rows.Add(rowData);
if (Convert.ToBoolean(newAddedList[i]["enabled"]) == true & (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString()) || string.IsNullOrEmpty(newAddedList[i]["giftNo"].ToString())))
{
Alert.ShowInTop("商品编码或赠品编码不可为空！");
return;
}
origGoodsId = getGoodIdByNo(newAddedList[i]["goodsNo"].ToString().Trim());
giftGoodsId = getGoodIdByNo(newAddedList[i]["giftNo"].ToString().Trim());
if (origGoodsId == 0 || giftGoodsId == 0)
{
Alert.ShowInTop("商品编码不存在，请校验！");
return;
}
sqlCmd = "insert into SaleAct (origGoodsId,giftGoodsId,enabled,startDte,endDte) values ";
sqlCmd += "(" + origGoodsId + "," + giftGoodsId + ",'" + Convert.ToBoolean(newAddedList[i]["enabled"]) + "',";
sqlCmd += "'" + Convert.ToDateTime(newAddedList[i]["startDte"]) + "','" + Convert.ToDateTime(newAddedList[i]["endDte"]) + "')";
SqlSel_Pro.ExeSql(sqlCmd);
}
//表格数据重新绑定
bindGrid("ALL");
Alert.Show("保存成功！");
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
private DataTable bindGrid(string dateStr, string poNumb, int pageIndex, int pageSize)
{
//数据集行数
string sqlCmd = "select isnull(count(*),0) as rowsCount from sfyordertab where cust_po_num like '" + poNumb + "'";
sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "'";
int rowCount = Convert.ToInt32(SqlSel_Pro.GetSqlScale(sqlCmd));
Grid1.RecordCount = rowCount;
DataTable dt = new DataTable();
if (pageIndex == 0)
{
sqlCmd = " select top " + pageSize + " * from sfyordertab where cust_po_num like '" + poNumb + "'";
sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid";
}
else
{
sqlCmd = "select top " + pageSize + " * from sfyordertab where soid>(";
sqlCmd += " select max(soid) from ";
sqlCmd += " (select top (" + pageIndex + "*" + pageSize + ") soid from sfyordertab where cust_po_num like '" + poNumb + "'";
sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid) t)";
sqlCmd += " and cust_po_num like '" + poNumb + "'";
sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid";
}
if (SqlSel_Pro.GetSqlSel(ref dt, sqlCmd))
{
string tradeNo = string.Empty;
DataTable apiDt = new DataTable();
dt.Columns.Add("isAPI", typeof(string));
dt.Columns.Add("APIStatus", typeof(bool));
string str = "";
foreach (DataRow dr in dt.Rows)
{
tradeNo = dr["OrderId"].ToString();
str += " tradeNo='" + tradeNo + "' or";
}
sqlCmd = "select tradeNo from g_api_tradelist where " + str.Substring(0, str.Length - 2);
if (!SqlSel.GetSqlSel(ref apiDt, sqlCmd))
{
foreach (DataRow dr in dt.Rows)
{
if (dr["isNew"].ToString() == "1")
{
dr["isAPI"] = "异常";
dr["APIStatus"] = true;
}
else
{
dr["isAPI"] = "待同步";
dr["APIStatus"] = false;
continue;
}
}
}
else
{
foreach (DataRow dr in dt.Rows)
{
tradeNo = dr["OrderId"].ToString();
if (dr["isNew"].ToString() == "1")
{
DataRow[] drArr = apiDt.Select("tradeNo='" + tradeNo + "'");
if (drArr.Length > 0)
{
dr["isAPI"] = "";
dr["APIStatus"] = false;
}
else
{
dr["isAPI"] = "异常";
dr["APIStatus"] = true;
}
}
else
{
dr["isAPI"] = "待同步";
dr["APIStatus"] = false;
continue;
}
}
}
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 发送反馈
/// </summary>
/// <param name="OrderNO">订单号</param>
/// <param name="SndStyle">物流方式</param>
/// <param name="BillID">物流单号</param>
/// <returns></returns>
public void mSndSFY(string OrderNO, string SndStyle, string BillID, string tradeNo, string sendTime, string shopId)
{
try
{
int i = OrderNO.Split(',').Length - 1;
string IPAddress = IPHelp.ClientIP;
DataTable dt2 = new DataTable();
foreach (var id in OrderNO.Split(','))
{
if (id.Contains("-"))
{
string sqlstr = "select * from WDApiFH where OrderId='" + id + "' and LOG_INFO='" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "'";
SqlSel.GetSqlSel(ref dt2, sqlstr);
if (dt2.Rows.Count > 0)
{
continue;
}
else
{
string dtbln = id.Split('-')[0];
string dline = id.Substring(dtbln.Length + 1);
string qunty = "0";
string sqlCmd2 = "insert into WDApiFH ([Header_ID],[Line_ID],[OrderId],[TQuantity],[LOG_INFO],[FHSat],[Create_Date],[TradeNO],[sendTime],cipher) values ('" + dtbln + "','" + dline + "','" + id + "','" + qunty + "','" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "','0','" + DateTime.Now + "','" + tradeNo + "','" + sendTime + "','" + shopId + "')";
//执行发货同步
int execounts2 = SqlSel.ExeSql(sqlCmd2);
if (execounts2 == 0)
{
label_mark.Text = string.Format("执行发货同步失败，SQL语句：{0}", sqlCmd2);
return;
}
}
}
if (id.Contains("SFY"))
{
string sqlCmdStr = "select parentid from SFYOrderTab where OrderId='" + id + "'";
string orgId = SqlSel_Pro.GetSqlScale(sqlCmdStr).ToString();
sqlCmdStr = "select * from WDApiFH where OrderId='" + orgId + "' and LOG_INFO='" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "'";
SqlSel.GetSqlSel(ref dt2, sqlCmdStr);
if (dt2.Rows.Count > 0)
{
continue;
}
else
{
string dtbln = orgId.Split('-')[0];
string dline = orgId.Substring(dtbln.Length + 1);
string qunty = "0";
string sqlCmd2 = "insert into WDApiFH ([Header_ID],[Line_ID],[OrderId],[TQuantity],[LOG_INFO],[FHSat],[Create_Date],[TradeNO],[sendTime]) values ('" + dtbln + "','" + dline + "','" + orgId + "','" + qunty + "','" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "','0','" + DateTime.Now + "','" + tradeNo + "','" + sendTime + "')";
//执行发货同步
int execounts2 = SqlSel.ExeSql(sqlCmd2);
if (execounts2 == 1)
{
}
}
}
else
{
continue;
}
}
//string sqlCmdt = "insert into WDApi_logs ([PageUrl],[AddedTime],[UserName],[IPAddress],[Privilege],[Description]) values ('','" + DateTime.Now + "','wdgj_api','" + IPAddress + "','发货同步','" + string.Format("【wdgj_发货同步】订单号:{0}，同步时间{1}，发货类型:{2},快递单号:{3} ", OrderNO.Replace(',', '，'), DateTime.Now, SndStyle, BillID) + "')";
//执行插入日志
//int execountst = SqlSel_Pro.ExeSql(sqlCmdt);
}
catch (Exception ex)
{
Label_status.Text = ex.Message;
Timer1.Enabled = false;
}
}
