protected void btnpass_Click(object sender, EventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid2.GetModifiedDict();
if (modifiedDict.Count == 0)
{
ShowNotify("没有任何数据修改！");
return;
}
foreach (int rowIndex in modifiedDict.Keys)
{
int SN = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
ProduceOrderRec produceOrderRec = MYDB.produceOrderRec.Where(u => u.SN == SN).FirstOrDefault();
UpdateDataRow(modifiedDict[rowIndex], produceOrderRec);
}
MYDB.SaveChanges();
BindGrid2();
}
protected void btnSend_Click(object sender, EventArgs e)
{
string mark = GetQueryValue("mark");
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
if (newAddedList.Count == 0)
{
ShowNotify("没有要提交的数据");
return;
}
StockHeader stockHeader = new StockHeader();
if (mark == "02")
{
stockHeader.title = "委外进货单";
}
else if (mark == "03")
{
stockHeader.title = "委外出货单";
}
stockHeader.optdate = DateTime.Now;
//执行存储过程获取流水号
SQLHelper.DbHelperSQL.SetConnectionString("");
object[] obj = new object[] { "WW" };
DataTable dt = SQLHelper.DbHelperSQL.ExecuteProc_ReturnDataTable("GetSeq", obj, 10);
string prosn = dt.Rows[0][0].ToString();
string StockHeaderProsn = "WW" + prosn;
ShowNotify(StockHeaderProsn);
stockHeader.StockHeaderProsn = StockHeaderProsn;
stockHeader.jingbanren = GetChineseName();
MYDB.StockHeaders.Add(stockHeader);
for (int i = 0; i < newAddedList.Count; i++)
{
SendOutStockList item = new SendOutStockList();
item.Barcode = newAddedList[i]["barcode"].ToString();
//订单号
item.StockOrderNo = newAddedList[i]["saleno"].ToString();
item.SendOutOrderNo = newAddedList[i]["orderno"].ToString();
item.ItemNo = newAddedList[i]["itemno"].ToString();
item.ProNo = newAddedList[i]["prono"].ToString();
item.ItemName = newAddedList[i]["itemname"].ToString();
item.Spec = newAddedList[i]["spec"].ToString();
item.Quantity = decimal.Parse(newAddedList[i]["qut"].ToString());
item.Space = newAddedList[i]["space"].ToString();
item.Remark = newAddedList[i]["remark"].ToString();
if (mark == "02")
{
item.SendOutProperties = SendOutProperties.委外入库;
}
else
{
item.SendOutProperties = SendOutProperties.委外出库;
}
item.Mark = mark;
item.Unit = newAddedList[i]["unit"].ToString();
item.PDate = DateTime.Now;
item.StockHeaderProsn = StockHeaderProsn;
MYDB.SendOutStockLists.Add(item);
}
MYDB.SaveChanges();
ShowNotify("提交成功");
//清除页面数据
PageContext.RegisterStartupScript("clearLocalStorage()");
}
public ConversationReplyModel()
{
myDB = new MYDB();
}
protected void btnSend_Click(object sender, EventArgs e)
{
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
if (newAddedList.Count == 0)
{
ShowNotify("没有要提交的数据");
return;
}
String status = GetQueryValue("status");
for (int i = 0; i < newAddedList.Count; i++)
{
string barcode = newAddedList[i]["barcode"].ToString();
MYDB.purchaseorderDetail.Where(u => u.BarCode == barcode).Update(u => new PurchaseOrderDetail
{
Status = int.Parse(status)
});
}
StockHeader stockHeader = new StockHeader();
stockHeader.title = "采购进货单";
stockHeader.optdate = DateTime.Now;
//执行存储过程获取流水号
SQLHelper.DbHelperSQL.SetConnectionString("");
object[] obj = new object[] { "JH" };
DataTable dt = SQLHelper.DbHelperSQL.ExecuteProc_ReturnDataTable("GetSeq", obj, 10);
string prosn = dt.Rows[0][0].ToString();
string StockHeaderProsn = "JH" + prosn;
ShowNotify(StockHeaderProsn);
stockHeader.StockHeaderProsn = StockHeaderProsn;
stockHeader.jingbanren = GetChineseName();
MYDB.StockHeaders.Add(stockHeader);
for (int i = 0; i < newAddedList.Count; i++)
{
PurchaseStockList item = new PurchaseStockList();
string barcode = newAddedList[i]["barcode"].ToString();
var purdetail = MYDB.purchaseorderDetail.Where(u => u.BarCode == barcode).FirstOrDefault();
item.Barcode = newAddedList[i]["barcode"].ToString();
//订单号
item.StockOrderNo = newAddedList[i]["saleno"].ToString();
item.PurOrderNo = newAddedList[i]["orderno"].ToString();
item.ItemNo = newAddedList[i]["itemno"].ToString();
item.ProNo = newAddedList[i]["prono"].ToString();
item.ItemName = newAddedList[i]["itemname"].ToString();
item.Spec = newAddedList[i]["spec"].ToString();
item.result = purdetail.result;
item.ChoujianQut = purdetail.ChoujianQut;
item.checkDate = purdetail.CheckDate;
item.Quantity = decimal.Parse(newAddedList[i]["qut"].ToString());
item.Space = newAddedList[i]["space"].ToString();
item.Remark = newAddedList[i]["remark"].ToString();
item.PurchaseProperties = PurchaseProperties.采购入库;
item.Mark = "02";
item.Unit = newAddedList[i]["unit"].ToString();
item.PDate = DateTime.Now;
item.StockHeaderProsn = StockHeaderProsn;
MYDB.PurchaseStockLists.Add(item);
}
MYDB.SaveChanges();
ShowNotify("提交成功");
//清除页面数据
PageContext.RegisterStartupScript("clearLocalStorage()");
}
public BookmarkModel()
{
myDB = new MYDB();
}
public NotificationModel()
{
myDB = new MYDB();
}