/// <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
{
int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString());
var model2 = new OUT_BACK01(x => x.Id == id);
//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"]["BK_ID01"].ToString()))
{
model2.BK_ID = jarr[i]["values"]["BK_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.Cdbl(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.QUAN1 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN101"].ToString());
model2.QUAN2 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN201"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
model2.REASON_ID = jarr[i]["values"]["REASON_ID01"].ToString();
model2.BAT_NO = jarr[i]["values"]["BAT_NO"].ToString();
model2.Exp_DateTime = DateTime.Now;
OUT_BACK01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
LoadDETAIL();
return(result);
}
/// <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
{
int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString());
var model2 = new Inventory01(x => x.Id == id);
//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(tbxINV_ID.Text))
{
model2.INV_ID = tbxINV_ID.Text;
}
else
{
return("保存失败");
}
model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString());
model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString();
model2.QUANTITY = ConvertHelper.Cdbl(jarr[i]["values"]["QUANTITY01"].ToString());
model2.QUAN = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN01"].ToString());
model2.QUAN1 = ConvertHelper.Cint(jarr[i]["values"]["QUAN101"].ToString());
model2.QUAN2 = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN201"].ToString());
model2.QUAN_B = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN_B01"].ToString());
model2.MEMO = jarr[i]["values"]["MEMO01"].ToString();
Inventory01Bll.GetInstence().Save(this, model2);
}
catch (Exception err)
{
n++;
result = "明细保存失败" + n + "条";
}
}
LoadDETAIL();
return(result);
}
/// <summary>获得Post提交的参数值,判断是否double,是返回,否返回0</summary>
/// <param name="strName">表单参数</param>
/// <returns>返回double型</returns>
public static double PostDouble(string strName)
{
string str = GetFormString(strName);
if (str.Length > 0 && ConvertHelper.IsNumeric(str))
{
return(ConvertHelper.Cdbl(str));
}
else
{
return(0);
}
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonPRODAdd_Click(object sender, EventArgs e)
{
FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
string _Pur00_ID = hidPurchase_ID.Text;
string _Shop_ID = ddlSHOP_NAME.SelectedValue;
string _Shop_Name = ddlSHOP_NAME.SelectedText;
string result = "";
var m_Shop = new SHOP00(x => x.SHOP_ID == _Shop_ID);
string _priceArea_id = m_Shop.SHOP_Price_Area;
int rowCount = Grid2.Rows.Count;
if (!String.IsNullOrEmpty(_Pur00_ID))
{
foreach (int i in selections)
{
string _Prod_ID = Grid4.DataKeys[i][0].ToString();
string _prod_name = Grid4.DataKeys[i][1].ToString();
string checkresult = ProdAddCheck(_Prod_ID, _prod_name);
if (!String.IsNullOrEmpty(checkresult))
{
result = result + "\r\n" + checkresult;
continue;
}
string _shop_id = ddlSHOP_NAME.SelectedValue;
var model = new V_Product01_PRCAREA(x => x.PROD_ID == _Prod_ID && x.PRCAREA_ID == _priceArea_id);
JObject deObject = new JObject();
deObject.Add("Id01", "0");
deObject.Add("SHOP_ID01", _Shop_ID);
deObject.Add("SHOP_NAME01", _Shop_Name);
deObject.Add("Purchase_ID01", _Pur00_ID);
rowCount = rowCount + 1;
deObject.Add("SNo01", rowCount);
deObject.Add("PROD_ID01", _Prod_ID);
deObject.Add("PROD_NAME01", model.PROD_NAME1);
deObject.Add("PROD_NAME02", model.PROD_NAME1);
deObject.Add("QUANTITY01", model.ORDER_QUAN);
deObject.Add("STD_UNIT01", model.Purchase_UNIT);
deObject.Add("STD_UNIT_NAME01", model.Purchase_UNIT_NAME);
deObject.Add("STD_CONVERT01", model.Purchase_CONVERT);
deObject.Add("STD_QUAN01", model.Purchase_QUAN);
deObject.Add("STD_PRICE01", model.Purchase_PRICE);
if (model.TAX_TYPE == '0')
{
deObject.Add("Tax01", 0);
}
else
{
deObject.Add("Tax01", ConvertHelper.Cdbl((model.Purchase_PRICE.ToString())) * ConvertHelper.Cdbl((model.Purchase_QUAN.ToString())) * ConvertHelper.Cdbl((model.Tax.ToString())) * 0.01);
}
deObject.Add("QUAN101", 0);
deObject.Add("QUAN201", 0);
deObject.Add("Item_DISC_Amt01", 0);
deObject.Add("MEMO", "");
deObject.Add("UNIT_NAME01", model.UNIT_NAME);
deObject.Add("UNIT_NAME101", model.UNIT_NAME1);
deObject.Add("UNIT_NAME201", model.UNIT_NAME2);
deObject.Add("PROD_CONVERT101", model.PROD_CONVERT1);
deObject.Add("PROD_CONVERT201", model.PROD_CONVERT2);
deObject.Add("SUP_COST01", model.SUP_COST);
deObject.Add("SUP_COST101", model.SUP_COST1);
deObject.Add("SUP_COST201", model.SUP_COST2);
deObject.Add("Tax_Num01", model.Tax);
deObject.Add("Tax_Type01", model.TAX_TYPE);
Grid2.AddNewRecord(deObject, true);
}
}
else
{
FineUI.Alert.ShowInParent("未选中订单无法添加", FineUI.MessageBoxIcon.Information);
}
if (!String.IsNullOrEmpty(result.Trim()))
{
FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Information);
}
}