public static List <px_PrintModel> Querypx_PrintList() { List <px_PrintModel> list = null; string sql2 = @" SELECT [id] ,[PXID] ,[orderid] ,[cartype] ,[XF] ,[LingjianHao] ,[sum] ,[ordername] ,[dayintime] ,[printpxid] ,[resultljh] ,[isauto] ,[SFlag] FROM [px_Print] order by id asc "; DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql2, null); if (DataHelper.HasData(dt)) { DataTable dt2 = dt; list = new List <px_PrintModel>(); foreach (DataRow row in dt2.Rows) { px_PrintModel model = new px_PrintModel(); model.id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "id")); model.isauto = DataHelper.GetCellDataToStr(row, "isauto"); model.PXID = DataHelper.GetCellDataToStr(row, "PXID"); model.orderid = DataHelper.GetCellDataToStr(row, "orderid"); model.cartype = DataHelper.GetCellDataToStr(row, "cartype"); model.XF = DataHelper.GetCellDataToStr(row, "XF"); model.sum = DataHelper.GetCellDataToStr(row, "sum"); model.ordername = DataHelper.GetCellDataToStr(row, "ordername"); model.LingjianHao = DataHelper.GetCellDataToStr(row, "LingjianHao"); model.dayintime = NumericParse.StringToDateTime(DataHelper.GetCellDataToStr(row, "dayintime")); model.printpxid = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "printpxid")); model.resultljh = DataHelper.GetCellDataToStr(row, "resultljh"); model.SFlag = DataHelper.GetCellDataToStr(row, "SFlag"); list.Add(model); } } return(list); }
void UpdaloadImg(string path) { //接收上传后的文件 HttpPostedFile file = Request.Files["Filedata"]; string datePath = DateTime.Now.Date.ToString(); //其他参数 //string somekey = context.Request["someKey"]; //string other = context.Request["someOtherKey"]; //获取文件的保存路径 string uploadPath = HttpContext.Current.Server.MapPath("\\UploadImages\\" + path + "\\"); //判断上传的文件是否为空 if (file != null) { if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } int dotIndex = file.FileName.LastIndexOf('.'); string extStr = file.FileName.Substring(file.FileName.LastIndexOf('.'), file.FileName.Length - dotIndex); string beforStr = file.FileName.Substring(0, file.FileName.LastIndexOf('.')); string newFilename = beforStr + "_" + NumericParse.StringToDateTime(DateTime.Now.ToString(), "yyyyMMddhhmmss") + extStr; FileInfo defile = new FileInfo(uploadPath + newFilename); if (defile.Exists) { defile.Delete(); } //保存文件 file.SaveAs(uploadPath + newFilename); Response.Write("/UploadImages/" + path + "/" + newFilename); } else { Response.Write("0"); } Response.End(); }
void queryMaterialsortprintingList() { string page = Request.Params["page"]; string pagesize = Request.Params["rows"]; DateTime?starttime = NumericParse.StringToDateTime(Request.Params["starttime"]); DateTime?endtime = NumericParse.StringToDateTime(Request.Params["endtime"]); string csh = Request.Params["csh"]; if (string.IsNullOrEmpty(page)) { page = "1"; } if (string.IsNullOrEmpty(pagesize)) { pagesize = "10"; } string json = px_MaterialsortprintingBLL.queryMaterialsortprintingList(page, pagesize, starttime, endtime, csh); Response.Write(json); Response.End(); }