//导出数据
protected void Button1_Click(object sender, EventArgs e)
{
string PacTime1 = PacTime.Value;
string Fpactate1 = Fpactate.Value;
string Pacpersonnel1 = Pacpersonnel.Value;
if (PacTime1 == "")
{
PacTime1 = "0";
}
if (Pacpersonnel1 == "")
{
Pacpersonnel1 = "0";
}
PackingModel rm = new PackingModel();
// DataBaseLayer db = new DataBaseLayer();
// string str = "select * from lossiInfor where type ='" + type + "'";
DataTable dt = rm.findPackingInfoDao(Fpactate1, Pacpersonnel1, PacTime1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "包装管理" + now);
}
public async Task <int> UpdateAsync(int id, PackingModel model)
{
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
await packingLogic.UpdateModelAsync(id, model);
var row = await dbContext.SaveChangesAsync();
//if (row > 0)
//{
// await CreateProduct(model);
//}
transaction.Commit();
return(row);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public List <PackingModel> GetPackings()
{
try
{
List <PackingModel> md = new List <PackingModel>();
var data = _tRSEntities.PackingMasters.ToList();
foreach (var item in data)
{
PackingModel pd = new PackingModel
{
id = item.id,
article = item.article,
item = item.item,
actualWeight1 = item.actualWeight,
packingType = item.packingType
};
md.Add(pd);
}
return(md);
}
catch (Exception e)
{
throw e;
}
}
public async Task <IActionResult> PostPacking([FromBody] PackingModel packings)
{
try
{
service.Username = User.Claims.Single(p => p.Type.Equals("username")).Value;
bool success = await service.CreateProduct(packings);
if (success)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.CREATED_STATUS_CODE, General.OK_MESSAGE)
.Ok();
return(NoContent());
}
else
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, "Failed to create product!")
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
catch (Exception e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
public async Task <int> CreateAsync(PackingModel model)
{
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
do
{
model.Code = CodeGenerator.Generate();
}while (dbSet.Any(d => d.Code.Equals(model.Code)));
packingLogic.CreateModel(model);
var row = await dbContext.SaveChangesAsync();
if (row > 0)
{
await CreateProduct(model);
}
transaction.Commit();
return(row);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public async Task CreateProduct(PackingModel model)
{
var client = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService));
var uri = string.Format("{0}{1}", Utilities.APIEndpoint.Core, "master/products/packing/create");
var myContentJson = JsonConvert.SerializeObject(model);
var myContent = new StringContent(myContentJson, Encoding.UTF8, "application/json");
var response = await client.PostAsync(uri, myContent);
response.EnsureSuccessStatusCode();
}
private PackingReceiptModel GetPackingReceipt(PackingModel packingModel)
{
return(new PackingReceiptModel()
{
PackingId = packingModel.Id,
Items = new List <PackingReceiptItem>()
{
new PackingReceiptItem()
}
});
}
public async Task <int> CreateAsync(PackingModel model)
{
do
{
model.Code = CodeGenerator.Generate();
}while (dbSet.Any(d => d.Code.Equals(model.Code)));
packingLogic.CreateModel(model);
var row = await dbContext.SaveChangesAsync();
if (row > 0)
{
await packingLogic.CreateProduct(model);
}
return(row);
}
public bool SavePacking(PackingModel model)
{
try
{
PackingMaster ms = new PackingMaster();
ms.article = model.article;
ms.item = model.item;
ms.actualWeight = model.actualWeight1;
ms.packingType = model.packingType;
_tRSEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public static bool deletePackingById(string strRowIds)
{
int a = 0;
bool result;
string[] strRows1Id = strRowIds.Split(',');
for (int i = 0; i < strRows1Id.Length; i++)
{
PackingModel rm = new PackingModel();
a = rm.deletePackingInfo(Convert.ToInt16(strRows1Id[i]));
}
if (a == 0)
{
result = false;
}
else
{
result = true;
}
return(result);
}
public async Task <int> UpdateAsync(int id, PackingModel model)
{
packingLogic.UpdateModelAsync(id, model);
return(await dbContext.SaveChangesAsync());
}
public BookingModel GetBooking(int id)
{
try
{
List <PackingModel> packingModels = new List <PackingModel>();
var check = _tRSEntities.BookingMasters.Where(x => x.id == id && x.isActive == true).FirstOrDefault();
if (check != null)
{
BookingModel model = new BookingModel();
model.cn = check.cn;
model.expectedDelivery = check.expectedDelivery;
model.from = check.from;
var from = _tRSEntities.BranchMasters.Where(x => x.id == model.from).FirstOrDefault();
if (from != null)
{
model.fromName = from.branchCode;
}
model.to = check.to;
var to = _tRSEntities.BranchMasters.Where(x => x.id == model.to).FirstOrDefault();
if (to != null)
{
model.toName = to.branchCode;
}
model.godownNo = check.godownNo;
var godownName = _tRSEntities.GodownMasters.Where(x => x.id == check.godownNo).FirstOrDefault();
if (godownName != null)
{
model.godownName = godownName.godownName;
}
model.paymentType = check.paymentType;
model.actualWeight = check.actualWeight;
model.consignee = check.consignee;
var consigneeName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.consignee).FirstOrDefault();
if (consigneeName != null)
{
model.consigneeName = consigneeName.clientCode;
}
//third day
model.cnNo = check.cnNo;
model.deliveryBranch = check.deliveryBranch;
var deliveryBranchName = _tRSEntities.BranchMasters.Where(x => x.id == check.deliveryBranch).FirstOrDefault();
if (deliveryBranchName != null)
{
model.deliveryBranchName = deliveryBranchName.deliveryAgainstAs;
}
model.virtualGoddownNo = check.virtualGoddownNo;
var virtualGoddownName = _tRSEntities.VirtualGodownMasters.Where(x => x.id == check.virtualGoddownNo).FirstOrDefault();
if (virtualGoddownName != null)
{
model.virtualGoddownName = virtualGoddownName.virtualGodownCode;
}
model.consignorDetails = check.consignorDetails;
model.consignor = check.consignor;
var consignorName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.consignor).FirstOrDefault();
if (consignorName != null)
{
model.consignorName = consignorName.gstIN;
}
model.agentName = check.agentName;
var clientName = _tRSEntities.RegularClientMasters.Where(x => x.id == check.agentName).FirstOrDefault();
if (clientName != null)
{
model.clientName = clientName.clientName;
}
model.agentDetails = check.agentDetails;
model.bookingType = check.bookingType;
model.deliveryType = check.deliveryType;
model.modeOfTransport = check.modeOfTransport;
model.invoiceNo = check.invoiceNo;
model.invoiceValue = check.invoiceValue;
model.consignorInvoice = check.consignorInvoice;
model.freightBasis = check.freightBasis;
model.ftl = check.ftl;
model.isCcAttached = check.isCcAttached;
model.isCod = check.isCod;
model.chargeWeight = check.chargeWeight;
model.freightRate = check.freightRate;
model.privateMark = check.privateMark;
model.insuredBy = check.insuredBy;
model.freight = check.freight;
model.surcharge = check.surcharge;
model.hamaliCharge = check.hamaliCharge;
model.localCartages = check.localCartages;
model.doorDeliveryCharge = check.doorDeliveryCharge;
model.statisticalCharges = check.statisticalCharges;
model.miscellaneousCharges = check.miscellaneousCharges;
model.godownCharges = check.godownCharges;
model.cod = check.cod;
model.riskCharge = check.riskCharge;
model.branch = check.branch;
model.reserveReason = check.reserveReason;
model.cnFrom = check.cnFrom;
model.cnTo = check.cnTo;
model.srtoNo = check.srtoNo;
model.lotNo = check.lotNo;
model.rollNo = check.rollNo;
model.meter = check.meter;
model.weightInKg = check.weightInKg;
var findPacketBooking = _tRSEntities.PackingMasters.Where(x => x.bookingId == id && x.isActive == true).ToList();
foreach (var item in findPacketBooking)
{
PackingModel pm = new PackingModel();
pm.id = item.id;
pm.article = item.article;
pm.actualWeight1 = item.actualWeight;
pm.packingType = item.packingType;
packingModels.Add(pm);
}
model.singleCn = packingModels;
return(model);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
public IHttpActionResult SavePacking(PackingModel model)
{
var data = packing.SavePacking(model);
return(Ok(data));
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
PackingModel rm = new PackingModel();
string Fpactate = "0";
if (p.extParam.ContainsKey("Fpactate"))
{
Fpactate = p.extParam["Fpactate"];
}
string Pacpersonnel = "0";
if (p.extParam.ContainsKey("Pacpersonnel"))
{
Pacpersonnel = p.extParam["Pacpersonnel"];
}
string PacTime = "0";
if (p.extParam.ContainsKey("PacTime"))
{
PacTime = p.extParam["PacTime"];
}
string StartTime = "0";
if (p.extParam.ContainsKey("StartTime"))
{
StartTime = p.extParam["StartTime"];
}
if (PacTime == "")
{
PacTime = "0";
}
if (Pacpersonnel == "")
{
Pacpersonnel = "0";
}
if (StartTime == "")
{
StartTime = "0";
}
dotNetFlexGrid.FieldFormatorHandle proc1 = delegate(DataRow dr)
{
if (dr["warningstatus"].ToString() == "1")
{
return("<span style='color:red'>黄色预警</span>");
}
else
{
return("<span style='color:black'>暂无预警</span>");
}
};
result.FieldFormator.Register("warningstatus", proc1);
result.table = rm.findPackingInfo(Fpactate, Pacpersonnel, PacTime, StartTime);
dotNetFlexGrid.FieldFormatorHandle proc2 = delegate(DataRow dr)
{
int bstatus = Convert.ToInt32(dr["Fpactate"].ToString());
if (bstatus == 1)
{
return("包装完成");
}
else
{
return("开始包装");
}
};
result.FieldFormator.Register("Fpactate", proc2);
return(result);
}
public async Task <bool> CreateProduct(PackingModel packings)
{
var productNames = (from packingDetail in packings.PackingDetails
select string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction,
packingDetail.Lot, packingDetail.Grade, packingDetail.Length) +
(string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark)))
.Except((from product in DbSet where product._IsDeleted == false select product.Name));
if (productNames.Count() > 0)
{
var uomId = (from uom in DbContext.UnitOfMeasurements
where uom.Unit == packings.PackingUom && uom._IsDeleted == false
select uom.Id).FirstOrDefault();
if (uomId == 0)
{
Uom uom = new Uom
{
Active = true,
Unit = packings.PackingUom,
_IsDeleted = false,
_CreatedBy = this.Username,
_CreatedUtc = DateTimeOffset.Now.DateTime,
_CreatedAgent = UserAgent
};
await DbContext.UnitOfMeasurements.AddAsync(uom);
await DbContext.SaveChangesAsync();
uomId = uom.Id;
}
var tags = string.Format("sales contract #{0}", packings.SalesContractNo);
CodeGenerator codeGenerator = new CodeGenerator();
IEnumerable <Product> products = from packingDetail in packings.PackingDetails
where productNames.Contains(string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction,
packingDetail.Lot, packingDetail.Grade, packingDetail.Length) +
(string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark)))
select new Product
{
Active = true,
Code = codeGenerator.GenerateCode(),
Name = string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction,
packingDetail.Lot, packingDetail.Grade, packingDetail.Length) +
(string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark)),
UomId = uomId,
UomUnit = packings.PackingUom,
Tags = tags,
SPPProperties = new ProductSPPProperty()
{
ProductionOrderId = packings.ProductionOrderId,
ProductionOrderNo = packings.ProductionOrderNo,
DesignCode = packings.DesignCode,
DesignNumber = packings.DesignNumber,
OrderTypeId = packings.OrderTypeId,
OrderTypeCode = packings.OrderTypeCode,
OrderTypeName = packings.OrderTypeName,
BuyerId = packings.BuyerId,
BuyerName = packings.BuyerName,
BuyerAddress = packings.BuyerAddress,
ColorName = packings.ColorName,
Construction = packings.Construction,
Lot = packingDetail.Lot,
Grade = packingDetail.Grade,
Weight = packingDetail.Weight,
Length = packingDetail.Length
},
_IsDeleted = false,
_CreatedBy = this.Username,
_CreatedUtc = DateTimeOffset.Now.DateTime,
_CreatedAgent = UserAgent
};
await DbContext.AddRangeAsync(products);
var rowAffected = await DbContext.SaveChangesAsync();
if (rowAffected > 0)
{
return(true);
}
}
else
{
return(true);
}
return(false);
}
public PackingPdfTemplate(PackingModel model, int timeoffset)
{
#region Data Preparation
var OrderType = ((model.OrderTypeName ?? string.Empty) == PRINTING) ? PRINTING : FINISHING;
#region Header
IEnumerable <string> headerLefts = new List <string> {
HEADER_LEFT_1, string.Format("{0} {1}", HEADER_LEFT_2, OrderType)
};
List <string> headerRights1 = new List <string> {
HEADER_RIGHT_1, HEADER_RIGHT_2
};
List <string> headerRights2 = new List <string> {
string.Format("{0} {1}", SPLITTER, model.Code), string.Format("{0} {1}", SPLITTER, model.ProductionOrderNo)
};
#endregion
#region Body
IEnumerable <string> bodyColumn = new List <string> {
"Barang", string.Format("Jumlah ({0})", model.PackingUom),
"Panjang (Meter)", "Panjang Total (Meter)", "Berat Total (Kg)", "Keterangan"
};
List <List <string> > bodyData = new List <List <string> >
{
model.PackingDetails.Select(m => string.Format("{0} {1} {2} {3}", model.ColorName, m.Lot, m.Grade, (m.Grade.ToLower() == "a" ? "BQ" : "BS"))).ToList(),
model.PackingDetails.Select(m => m.Quantity.ToString("#,#", CultureInfo.InvariantCulture)).ToList(),
model.PackingDetails.Select(m => m.Length.ToString("#,#", CultureInfo.InvariantCulture)).ToList(),
model.PackingDetails.Select(m => (m.Quantity * m.Length).ToString("#,#", CultureInfo.InvariantCulture)).ToList(),
model.PackingDetails.Select(m => (m.Quantity * m.Weight).ToString("#,#", CultureInfo.InvariantCulture)).ToList(),
model.PackingDetails.Select(m => m.Remark).ToList()
};
IEnumerable <string> totalData = new List <string>
{
model.PackingDetails.Select(m => m.Quantity).Sum().ToString("#,#", CultureInfo.InvariantCulture),
model.PackingDetails.Select(m => m.Length).Sum().ToString("#,#", CultureInfo.InvariantCulture),
model.PackingDetails.Select(m => (m.Quantity * m.Length)).Sum().ToString("#,#", CultureInfo.InvariantCulture),
model.PackingDetails.Select(m => (m.Quantity * m.Weight)).Sum().ToString("#,#", CultureInfo.InvariantCulture)
};
#endregion
#region Body Footer
List <string> footerHeaders = new List <string>();
List <string> footerValues = new List <string>();
if (model.OrderTypeName.ToLowerInvariant() == SOLID.ToLower())
{
footerHeaders = new List <string> {
BUYER, ORDER_TYPE, COLOUR_TYPE, CONSTRUCTION, DESTINATION
};
footerValues = new List <string> {
model.BuyerName, OrderType, model.ColorType, model.Construction, model.BuyerAddress
};
}
else if (model.OrderTypeName.ToLowerInvariant() == PRINTING.ToLower())
{
footerHeaders = new List <string> {
BUYER, ORDER_TYPE, CONSTRUCTION, DESIGN_PATTERN, DESTINATION
};
footerValues = new List <string> {
model.BuyerName, OrderType, model.Construction,
string.IsNullOrWhiteSpace(model.DesignNumber) && string.IsNullOrWhiteSpace(model.DesignCode) ?
string.Format("{0} - {1}", model.DesignNumber, model.DesignCode) : string.Empty, model.BuyerAddress
};
}
else
{
footerHeaders = new List <string> {
BUYER, ORDER_TYPE, CONSTRUCTION, DESTINATION
};
footerValues = new List <string> {
model.BuyerName, OrderType, model.Construction, model.BuyerAddress
};
}
#endregion
#endregion
this.Title = this.GetTitle();
this.Header = this.GetHeader(headerLefts, headerRights1, headerRights2);
this.Body = this.GetBody(bodyColumn, bodyData, totalData);
this.BodyFooter = this.GetBodyFooter(footerHeaders, footerValues);
this.Footer = this.GetFooter(model.Date.AddHours(timeoffset), model.CreatedBy);
}
public async Task <bool> CreateProduct(PackingModel packings)
{
//DbContext.Database.SetCommandTimeout(1000 * 60 * 10);
var packingProducts = packings.PackingDetails.Select(packingDetail => string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction,
packingDetail.Lot, packingDetail.Grade, packingDetail.Length) +
(string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark))).ToList();
//var productNames = (from packingDetail in packings.PackingDetails
// select )
// .Except((from product in DbSet where product._IsDeleted == false select product.Name));
var uom = DbContext.UnitOfMeasurements.FirstOrDefault(f => f.Unit.Equals(packings.PackingUom));
if (uom == null)
{
uom = new Uom
{
Active = true,
Unit = packings.PackingUom,
_IsDeleted = false,
_CreatedBy = this.Username,
_CreatedUtc = DateTimeOffset.Now.DateTime,
_CreatedAgent = UserAgent
};
DbContext.UnitOfMeasurements.Add(uom);
await DbContext.SaveChangesAsync();
//uomId = uom.Id;
}
var tags = string.Format("sales contract #{0}", packings.SalesContractNo);
CodeGenerator codeGenerator = new CodeGenerator();
var listProductToCreate = new List <Product>();
foreach (var packingDetail in packings.PackingDetails)
{
var packingProduct = string.Format("{0}/{1}/{2}/{3}/{4}/{5}", packings.ProductionOrderNo, packings.ColorName, packings.Construction, packingDetail.Lot, packingDetail.Grade, packingDetail.Length) + (string.IsNullOrWhiteSpace(packingDetail.Remark) ? "" : string.Format("/{0}", packingDetail.Remark));
var existingProduct = DbContext.Products.FirstOrDefault(f => f.Name.Equals(packingProduct));
if (existingProduct == null)
{
var productToCreate = new Product()
{
Active = true,
Code = codeGenerator.GenerateCode(),
Name = packingProduct,
UomId = uom.Id,
UomUnit = packings.PackingUom,
Tags = tags,
SPPProperties = new ProductSPPProperty()
{
ProductionOrderId = packings.ProductionOrderId,
ProductionOrderNo = packings.ProductionOrderNo,
DesignCode = packings.DesignCode,
DesignNumber = packings.DesignNumber,
OrderTypeId = packings.OrderTypeId,
OrderTypeCode = packings.OrderTypeCode,
OrderTypeName = packings.OrderTypeName,
BuyerId = packings.BuyerId,
BuyerName = packings.BuyerName,
BuyerAddress = packings.BuyerAddress,
ColorName = packings.ColorName,
Construction = packings.Construction,
Lot = packingDetail.Lot,
Grade = packingDetail.Grade,
Weight = packingDetail.Weight,
Length = packingDetail.Length
},
_IsDeleted = false,
_CreatedBy = this.Username,
_CreatedUtc = DateTimeOffset.Now.DateTime,
_CreatedAgent = UserAgent
};
listProductToCreate.Add(productToCreate);
}
}
if (listProductToCreate.Count > 0)
{
await DbContext.AddRangeAsync(listProductToCreate);
}
var rowAffected = await DbContext.SaveChangesAsync();
if (rowAffected > 0)
{
return(true);
}
else
{
return(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
String type = Request.QueryString["type"].ToString();
if ("save".Equals(type))
{
try
{
string imgbase64 = Request.Form["imgbase64"]; //图片
string tisaneNum = Request.Form["tisaneNum"]; //煎药单号
string userNum = Request.Form["userNum"]; //员工号
string barcode = Request.Form["barcode"]; //条形码
string userName = Request.Form["userName"]; //员工姓名
string imgname = null;
string nowDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (imgbase64 != null && imgbase64.Trim().Length > 0)
{
imgbase64 = imgbase64.Replace(' ', '+');
Byte[] bimg = Convert.FromBase64String(imgbase64);
//D:\\项目\\煎药厂\\src\\web\\upload\\
String path = System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "upload\\";
imgname = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".png";
FileBinaryConvertHelper.Bytes2File(bimg, path + imgname);
}
PackingModel rm = new PackingModel();
DataTable dt = rm.findPackingBybarcode(tisaneNum);
int result = 0;
if (dt.Rows.Count > 0)
{
if ("1".Equals(dt.Rows[0]["Fpactate"].ToString()))
{
result = 0;
}
else
{
result = rm.updatePackinginfo(Convert.ToInt32(dt.Rows[0]["id"].ToString()), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), tisaneNum);
}
}
else
{
RecipeModel rem = new RecipeModel();
DataTable dtable = rem.findTisaneFinish(Convert.ToInt32(tisaneNum));
if (dtable.Rows.Count > 0)
{
result = rm.addPacking(Convert.ToInt32(userNum), nowDate, barcode, tisaneNum, imgname, userName);
}
}
if (result > 0)
{
Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\"}");
}
else
{
Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}");
}
}
catch (Exception e1)
{
Response.Write("{\"code\":\"1\",\"msg\":\"操作失败\"}");
}
}
else if ("get".Equals(type))
{
String id = Request.QueryString["id"].ToString();
RecipeModel rm2 = new RecipeModel();
string warningid = rm2.getRetentionWarning(5);
PackingModel rm = new PackingModel();
DataTable dataTable = rm.findPackingInfo(Convert.ToInt32(id), DateTime.Now.ToString("yyyy-MM-dd"));
Response.Write("{\"code\":\"0\",\"msg\":\"操作成功\",\"data\":" + DataTableToJson.ToJson(dataTable) + ",\"warning\":\"" + warningid + "\"}");
}
}
