public void LoadDETAIL()
{
string _tbxINV_ID = tbxAD_ID.Text;
if (!String.IsNullOrEmpty(_tbxINV_ID))
{
List <ConditionFun.SqlqueryCondition> conditiondetail = new List <ConditionFun.SqlqueryCondition>();
conditiondetail.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, Adjust01Table.AD_ID, Comparison.Equals, _tbxINV_ID, false, false));
Adjust01Bll.GetInstence().BindGrid(Grid2, 0, 0, conditiondetail, sortList);
}
}
/// <summary>
/// 子表保存
/// </summary>
/// <returns></returns>
public string DetailEdit()
{
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 Adjust01();
//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"]["AD_ID01"].ToString()))
{
model2.AD_ID = jarr[i]["values"]["AD_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.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
Adjust01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
return(result);
}
