/// <summary>
/// 更新发货单信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateOrderLogistics(MSOrderLogistics model)
{
string safeslq = "";
safeslq = "UPDATE MS_OrderLogistics SET ";
if (model.OID != null && model.OID != "")
{
if (!safeslq.Trim().ToLower().Contains(","))
{
safeslq += ",";
}
safeslq += "OID='" + model.OID + "'";
}
if (model.CName != null && model.CName.ToString() != "")
{
if (!safeslq.Trim().ToLower().Contains(","))
{
safeslq += ",";
}
safeslq += "CName='" + model.CName + "'";
}
safeslq += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 订单发货
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddOrderLogistics(MSOrderLogistics model)
{
string sql = @"INSERT INTO [MS_OrderLogistics]
([ID],[OID],[CName],[AddTime])
VALUES
(@ID,@OID,@CName,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@OID", model.OID),
new System.Data.SqlClient.SqlParameter("@CName", model.CName),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
void GetHtmlPage()
{
string oid = string.Empty; MSOrderLogistics OLDetail = new MSOrderLogistics();
if (Request["oid"] != null && Request["oid"] != "")
{
oid = Common.Common.NoHtml(Request["oid"]);
}
if (oid != null && oid != "")
{
MSOrderLogisticsDAL OLdetail = new MSOrderLogisticsDAL();
DataSet ds = OLdetail.GetMSODetailByOID(oid);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
OLDetail = DataConvert.DataRowToModel <MSOrderLogistics>(ds.Tables[0].Rows[0]);
}
}
else
{
errormsg = JQDialog.alertOKMsgBox(5, "无效的请求方式", "", "error");
}
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/CopyOrder.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["errormsg"] = errormsg;
context.TempData["oldetail"] = OLDetail;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 提交订单
/// </summary>
void submitOrder()
{
string oid = string.Empty; string cid = string.Empty; string cname = string.Empty;
#region -获取页面请求值
try
{
oid = Request.Form.Get("ordernum").ToString();
}
catch (Exception)
{
oid = "";
}
try
{
cname = Request.Form.Get("cname").ToString();
}
catch (Exception)
{
cname = "";
}
try
{
cid = Request.Form.Get("cid").ToString();
}
catch (Exception)
{
cid = "";
}
#endregion
strSiteCode = "VYIGO"; string customerid = string.Empty; string openid = string.Empty;
if (oid != null && oid != "" && cid != null && cid != "")
{
MSOrderLogistics olModel = new MSOrderLogistics();
MSOrderLogisticsDAL olDal = new MSOrderLogisticsDAL();
MSProductOrderDAL OrderDal = new MSProductOrderDAL();
olModel.ID = cid; olModel.OID = oid; olModel.CName = cname;
customerid = OrderDal.GetOrderValueByID("CustomerID", oid).ToString();
if (customerid != null && customerid != "")
{
MSCustomersDAL customerDal = new MSCustomersDAL();
openid = customerDal.GetCustomerValueByID("OpenID", customerid).ToString();
}
if (olDal.AddOrderLogistics(olModel) && OrderDal.UpdateOrderState("IsSend", oid))
{
string buyName = string.Empty;
try
{
buyName = OrderDal.GetOrderValueByID("BuyName", oid).ToString();
WeiXinCore.WeiXin wx = WXHelper.CreateWeiXinInstanceBySiteCode(strSiteCode);
List <TemplateMessageParam> paramList = new List <TemplateMessageParam>();
paramList.Add(new TemplateMessageParam("first", "亲，宝贝已经启程了，好想快点来到你身边"));
paramList.Add(new TemplateMessageParam("delivername", cname));
paramList.Add(new TemplateMessageParam("ordername", cid));
paramList.Add(new TemplateMessageParam("remark",
"请关注公众号【vgo2013】进入“快点我”查看完整物流信息"));
SendTemplateMessageReturnObj temobj = wx.SendTemplateMessage(openid,
"k4eMeEtKReeDvDRFAf8-Li9FuuHkaFPP1xQI6t3Jomo",
"http://www.vgo2013.com/PalmShop/ShopCode/CopyOrder.aspx?oid=" + oid,
paramList.ToArray(), "");
MSOrderLogDAL.AddMSOrderLog("提示客户订单【" + oid + "】已经发货，发送模板消息到客户OpenID【" + openid + "】");
bool flag = true;
if (flag)
{
}
}
catch { }
errormsg = JQDialog.alertOKMsgBox(3, "操作成功！", "OrderDelivery.aspx", "succeed");
}
else
{
errormsg = JQDialog.alertOKMsgBoxGoBack(3, "操作失败，请重新操作！", false);
}
}
else
{
errormsg = JQDialog.alertOKMsgBoxGoBack(3, "操作失败，请重新操作！", false);
}
}
