/// <summary>
/// 添加订单及照片信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddPhotoSubmit(MSPhotoSubmit model)
{
string sql = @"INSERT INTO [MS_PhotoSubmit]
([ID],[UID],[OrderNum],[Img1],[Img2],[Reivew],[Pstate],[AddTime])
VALUES
(@ID,@UID,@OrderNum,@Img1,@Img2,@Reivew,@Pstate,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@UID", model.UID),
new System.Data.SqlClient.SqlParameter("@OrderNum", model.OrderNum),
new System.Data.SqlClient.SqlParameter("@Img1", model.Img1),
new System.Data.SqlClient.SqlParameter("@Img2", model.Img2),
new System.Data.SqlClient.SqlParameter("@Reivew", (model.Reivew == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@Pstate", (model.Pstate == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改订单及照片信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdatePhotoSubmit(MSPhotoSubmit model)
{
string safeslq = "";
safeslq = "UPDATE MS_PhotoSubmit SET ";
if (model.OrderNum != null && model.OrderNum != "")
{
safeslq += "OrderNum='" + model.OrderNum + "',";
}
if (model.Img1 != null && model.Img1 != "")
{
safeslq += "Img1='" + model.Img1 + "',";
}
if (model.Img2 != null && model.Img2.ToString() != "")
{
safeslq += "Img2='" + model.Img2 + "',";
}
safeslq += " Reivew=" + (model.Reivew == 1 ? 1 : 0) + ", ";
safeslq += " Pstate=" + (model.Pstate == 1 ? 1 : 0) + " ";
safeslq += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
void showdetailinfo()
{
printimg.Items.Clear();
printimg.Items.Insert(0, new ListItem("--请选择需打印的照片--", ""));
MSPhotoSubmitDAL photoDal = new MSPhotoSubmitDAL();
DataSet photods = photoDal.GetPhotoSubmitDetail(strID);
MSPhotoSubmit photomodel = DataConvert.DataRowToModel <MSPhotoSubmit>(photods.Tables[0].Rows[0]);
ordernum.Text = photomodel.OrderNum;
imgsrc1 = "../../PalmShop/ShopCode/" + photomodel.Img1;
imgsrc2 = "../../PalmShop/ShopCode/" + photomodel.Img2;
img1.Src = imgsrc1;
img2.Src = imgsrc2;
userid = photomodel.UID;
printimg.Items.Insert(1, new ListItem("照片1", photomodel.Img1));
printimg.Items.Insert(2, new ListItem("照片2", photomodel.Img2));
printimg.DataBind();
if (photomodel.Reivew == 0)
{
rno.Checked = true;
}
else
{
ryes.Checked = true;
}
}
/// <summary>
/// 订单提交
/// </summary>
void submitOrder()
{
string ordernum = string.Empty; int imgcount = 0;
string img1 = string.Empty; string img2 = string.Empty;
string openid = string.Empty; string userid = string.Empty;
if (Session["OpenID"] != null && Session["OpenID"].ToString() != "")
{
openid = Session["OpenID"].ToString();
}
if (openid != null && openid != "")
{
MSCustomersDAL customerDal = new MSCustomersDAL();
try
{
userid = customerDal.GetCustomerValueByOpenID("ID", openid).ToString();
}
catch (Exception)
{
}
}
#region -------------获取请求值------------
try
{
ordernum = Request.Form.Get("ordernum").ToString();
}
catch (Exception)
{
ordernum = "";
}
#endregion
try
{
imgcount = Request.Files.Count;
}
catch (Exception)
{
}
if (imgcount == 2)
{
img1 = UploadImg(0, "printimg", ordernum);
img2 = UploadImg(1, "shareimg", ordernum);
if (userid == null || userid == "" && ordernum != null && ordernum != "")
{
MSProductOrderDAL orderDal = new MSProductOrderDAL();
userid = orderDal.GetOrderValueByID("CustomerID", ordernum).ToString();
}
if (ordernum != null && ordernum != "")
{
MSPhotoSubmit photoModel = new MSPhotoSubmit();
MSPhotoSubmitDAL photoDal = new MSPhotoSubmitDAL();
photoModel.OrderNum = ordernum;
photoModel.Img1 = img1;
photoModel.Img2 = img2;
photoModel.UID = userid;
photoModel.ID = Guid.NewGuid().ToString("N").ToUpper();
if (!photoDal.AddPhotoSubmit(photoModel))
{
errormsg = JQDialog.alertOKMsgBoxGoBack(3, "操作失败，请重新操作！", false);
}
else
{
errormsg = JQDialog.alertOKMsgBox(3, "操作成功，请等待审核！", "PrintImgOrder.aspx", "succeed");
}
}
else
{
errormsg = JQDialog.alertOKMsgBoxGoBack(3, "请输入正确的订单！", false);
}
}
else
{
errormsg = JQDialog.alertOKMsgBoxGoBack(3, "请选择您要打印的照片和分享的照片！", false);
}
}
