public int recordorderpool(printorders po)
{
string msql = "insert into printorders(or_id,user_tel,s_id,s_name,or_payway,or_money,or_ifcarry,or_state,or_filenum,or_pagenum,or_upTime,or_location,or_remark,or_getcheck) " +
"values('" + po.or_id + "','" + po.user_tel + "','" + po.s_id + "','" + po.s_name + "','" + po.or_payway + "'," + po.or_money + "," + po.or_ifcarry + ",1," +
"'" + po.or_filenum + "','" + po.or_pagenum + "','" + po.or_upTime + "','" + po.or_location + "','" + po.or_remark + "','" + po.or_getcheck + "')";
return(mysqlDBhelper.dochangesql(msql));
}
/// <summary>
/// 存入数据库
/// </summary>
/// <returns></returns>
public string recordorderpool()
{
printorders po = new printorders();
/*生成订单编号*/
DateTime time = DateTime.Now;
po.or_id = produceOrderId(time);
/*接收其他信息*/
po.or_upTime = time.ToString();
string money = Request["money"].ToString();
po.or_money = float.Parse(money);
po.or_payway = "支付宝支付";
Session["store_id"] = Session["now_the_store_id"];
Session["store_name"] = Session["now_the_store_name"];
po.s_id = Session["store_id"].ToString();
po.s_name = Session["store_name"].ToString();
/*+"!"防止在转换为excel文件时自动识别为时间格式*/
po.or_location = Request["location"];
string order_files = Request["files"];//所有文件名
po.user_tel = Request["tel"];
po.or_remark = Request["remark"];
po.or_pagenum = Convert.ToInt32(Request["pagenum"]);
po.or_filenum = Convert.ToInt32(Request["filenum"]);
string getcheck = produceOrderCheck(time);//取货码
po.or_getcheck = getcheck;
po.or_ifcarry = Convert.ToInt32(Request["ifcarry"]);//是否送货上门
/*订单信息记录*/
int num = manp.recordorderpool(po);
/*文件打印信息记录*/
string filerepeat = Request["filerepeat"];
string filenarrow = Request["filenarrow"];
string fileside = Request["fileside"];
string pages = Request["pages"];
string realfilename = Request["realfilename"];
recordsinglefile(po.or_id, order_files, filerepeat, filenarrow, fileside, pages, realfilename);
/*已付款文件转移位置*/
changelocation(realfilename);
if (num > 0)
{
return(getcheck);
}
else
{
return(null);
}
}
public int recordorderpool()
{
printorders po = new printorders();
/*生成订单编号*/
DateTime time = DateTime.Now;
po.or_id = produceOrderId(time);
/*接收其他信息*/
po.or_upTime = time.ToString();
po.or_money = float.Parse(Request["money"]);
po.or_payway = "支付宝支付";
Session["store_id"] = "6666"; //临时
Session["store_name"] = "阿宝打印"; //临时
po.s_id = Session["store_id"].ToString();
po.s_name = Session["store_name"].ToString();
/*+"!"防止在转换为excel文件时自动识别为时间格式*/
po.or_location = Request["domitory"] + "!";
string order_files = Request["files"];//所有文件名
po.user_tel = Request["tel"];
po.or_remark = Request["remark"];
po.or_filenum = Convert.ToInt32(Request["filenum"]);
po.or_ifcarry = 0;//不急需，临时
/*订单信息记录*/
int num = manp.recordorderpool(po);
string filerepeat = Request["filerepeat"];
string filenarrow = Request["filenarrow"];
string fileside = Request["fileside"];
string pages = Request["pages"];
string realfilename = Request["realfilename"];
recordsinglefile(po.or_id, order_files, filerepeat, filenarrow, fileside, pages, realfilename);
/*已付款文件转移位置*/
changelocation(realfilename);
return(num);
}
public int recordorderpool(printorders po)
{
return(manp.recordorderpool(po));
}
