protected bool SaveToDB(string path, string tablename)
{
try
{
DataTable dt = ExcelManage.InputFromExcel(path, tablename);
if (dt != null && dt.Rows.Count > 0)
{
WsSystem wbi = new WsSystem();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString()))
{
BasBase bb = new BasBase();
bb.CODE = dt.Rows[i][0].ToString();
bb.NAME = dt.Rows[i][1].ToString();
bb.SubCode = dt.Rows[i][2].ToString();
bb.SubName = dt.Rows[i][3].ToString();
bb.MEMO = dt.Rows[i][4].ToString();
wbi.SaveBaseInfo(bb);
}
}
return(true);
}
else
{
Label1.Text = "上传完毕，但数据为空，保存失败";
}
return(true);
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
return(false);
}
}
public void FindBaseByCode()
{
string startTime = Context.Request.Form["startTime"];
string endTime = Context.Request.Form["endTime"];
string baseCode = Context.Request.Form["baseName"];
string rows = Context.Request.Form["rows"];
string page = Context.Request.Form["page"];
IList <BasBase> baseInfo = _bal.FindBaseByCode(startTime, endTime, baseCode);
List <BasBase> bs = new List <BasBase>();
int istart = (Convert.ToInt32(page) - 1) * Convert.ToInt32(rows);
int iend = Convert.ToInt32(page) * Convert.ToInt32(rows) + 1;
int j = 1;
foreach (BasBase bb in baseInfo)
{
if (j > istart && j < iend)
{
BasBase bbtemp = new BasBase();
bbtemp = bb;
bbtemp.UpdatedBy = FindUserNameByCode(bbtemp.UpdatedBy);
bs.Add(bbtemp);
}
j++;
}
Dictionary <String, Object> map = new Dictionary <String, Object>();
if (baseInfo != null & baseInfo.Count > 0)
{
map.Add("total", baseInfo.Count);
}
map.Add("rows", bs);
Context.Response.Write(JsonConvert.SerializeObject(map));
}
public string QueryProductINOrOut(string workorder, string status, string productname, string batchnumber, string starttime, string endtime)
{
if (status == "3")
{
status = "";
}
IList <ProductStockHistory> objs = _bal.FindProductStockHistory(status, workorder, productname, batchnumber, starttime, endtime);
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
sb.Append("<rows>");
string strstatus = string.Empty;
foreach (ProductStockHistory o in objs)
{
sb.Append(string.Format("<row id='{0}'>", o.ID));
sb.Append(string.Format("<cell>{0}</cell>", o.PSN));
sb.Append(string.Format("<cell>{0}</cell>", o.WorkOrder));
if (o.MANUFACTURE.Length == 13)
{
BasBase ibbb = _bal.FindNameBySubCode(o.MANUFACTURE);
sb.Append(string.Format("<cell>{0}</cell>", ibbb.SubName));
}
else
{
sb.Append(string.Format("<cell>{0}</cell>", o.MANUFACTURE));
}
sb.Append(string.Format("<cell>{0}</cell>", o.DOCUMENTID));
BasBase ibbbb = _bal.FindNameBySubCode(o.StockHouse);
sb.Append(string.Format("<cell>{0}</cell>", ibbbb.SubName));
sb.Append(string.Format("<cell>{0}</cell>", o.ProductCode));
sb.Append(string.Format("<cell>{0}</cell>", o.ProductName));
BasBase ibb = _bal.FindNameBySubCode(o.UNIT);
sb.Append(string.Format("<cell>{0}</cell>", ibb.SubName));
sb.Append(string.Format("<cell>{0}</cell>", o.QUANTITY.ToString()));
sb.Append(string.Format("<cell>{0}</cell>", o.BatchNumber));
sb.Append(string.Format("<cell>{0}</cell>", o.UpdatedBy));
sb.Append(string.Format("<cell>{0}</cell>", o.FromBy));
sb.Append(string.Format("<cell>{0}</cell>", o.UpdatedDate == null ? o.CreatedDate : o.UpdatedDate));
//sb.Append(string.Format("<cell>{0}</cell>", o.MEMO));
sb.Append("</row>");
}
sb.Append("</rows>");
return(sb.ToString());
}
