/// <summary> /// 子表保存 /// </summary> /// <returns></returns> public string TAKEN11Edit() { JArray jarr = Grid2.GetMergedData(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string result = ""; int n = 0; for (int i = 0; i < jarr.Count; i++) { try { var model2 = new TAKEIN11(); //string str = jarr[i]["status"].ToString(); if (jarr[i]["status"].ToString().Equals("modified")) { model2.SetIsNew(false); } else if (jarr[i]["status"].ToString().Equals("unchanged")) { continue; } else { model2.SetIsNew(true); } model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString(); if (!String.IsNullOrEmpty(jarr[i]["values"]["TAKEIN_ID01"].ToString())) { model2.TAKEIN_ID = jarr[i]["values"]["TAKEIN_ID01"].ToString(); } else { return("保存失败"); } model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString()); model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString(); model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString()); model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString(); model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString()); model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString()); model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString()); model2.Tax = ConvertHelper.StringToDecimal(jarr[i]["values"]["Tax01"].ToString()); model2.QUAN1 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN101"].ToString()); model2.QUAN2 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN201"].ToString()); model2.Item_DISC_Amt = ConvertHelper.StringToDecimal(jarr[i]["values"]["Item_DISC_Amt01"].ToString()); model2.MEMO = jarr[i]["values"]["MEMO01"].ToString(); model2.BAT_NO = jarr[i]["values"]["BAT_NO"].ToString(); model2.Exp_DateTime = DateTime.Now; TAKEIN11Bll.GetInstence().Save(this, model2); } catch (Exception err) { n++; result = "明细保存失败" + n + "条"; } } return(result); }
public void LoadTAKEN11() { string _takein_id = tbxTAKEIN_ID.Text; if (!String.IsNullOrEmpty(_takein_id)) { List <ConditionFun.SqlqueryCondition> conditiondetail = new List <ConditionFun.SqlqueryCondition>(); conditiondetail.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, TAKEIN11Table.TAKEIN_ID, Comparison.Equals, _takein_id, false, false)); TAKEIN11Bll.GetInstence().BindGrid(Grid2, 0, 0, conditiondetail, sortList); } }