public sgb_tb OfGetSgbModel(string pSgb01, int pSgb02)
{
DataRow drSgb = null;
sgb_tb rtnModel = null;
try
{
drSgb = OfGetSgbDr(pSgb01, pSgb02);
if (drSgb == null)
{
return(null);
}
rtnModel = drSgb.ToItem <sgb_tb>();
return(rtnModel);
}
catch (Exception ex)
{
throw ex;
}
}
//調整sdd_tb 產品客戶價格表
public bool OfInsUpdSddTb(sga_tb pSgaModel, sgb_tb pSgbModel, UserInfo pLoginInfo, out string pErrMsg)
{
sdd_tb sddModel = null;
int iChkCnts = 0;
List <SqlParameter> sqlParmList;
StringBuilder sbSql;
pErrMsg = "";
DataTable dtSdd;
DataRow drSdd;
try
{
sddModel = new sdd_tb();
sddModel.sdd01 = pSgbModel.sgb03; //料號
sddModel.sdd02 = pSgaModel.sga03; //客戶編號
sddModel.sdd03 = pSgaModel.sga10; //幣別
sddModel.sdd04 = pSgaModel.sga02; //最近訂單日期
sddModel.sdd05 = pSgbModel.sgb06; //銷售單位
sddModel.sdd06 = pSgaModel.sga06; //稅別
sddModel.sdd07 = pSgaModel.sga07; //稅率
sddModel.sdd08 = pSgaModel.sga08; //含稅否
sddModel.sdd09 = pSgbModel.sgb09; //銷售單價
sddModel.sdd10 = pSgbModel.sgb05; //最近訂單數量
if (pSgaModel.sga08 == "Y") //最近訂單金額
{
sddModel.sdd11 = pSgbModel.sgb10t;
}
else
{
sddModel.sdd11 = pSgbModel.sgb10;
}
sddModel.sdd12 = "";
sddModel.sdd13 = "";
sddModel.sdd14 = "";
sddModel.sdd15 = "";
sddModel.sdd16 = "";
sddModel.sdd17 = "";
sddModel.sdd18 = "";
sddModel.sdd19 = "";
sddModel.sdd20 = "";
sddModel.sddcreu = "";
sddModel.sddcreg = "";
sddModel.sddcred = null;
OfCreateDao("sdd_tb", "*", "");
sbSql = new StringBuilder();
sbSql.AppendLine("SELECT * FROM sdd_tb");
sbSql.AppendLine("WHERE sdd01=@sdd01");
sbSql.AppendLine("AND sdd02=@sdd02");
sbSql.AppendLine("AND sdd03=@sdd03");
sqlParmList = new List <SqlParameter>()
{
new SqlParameter("@sdd01", pSgbModel.sgb03),
new SqlParameter("@sdd02", pSgaModel.sga03),
new SqlParameter("@sdd03", pSgaModel.sga10)
};
dtSdd = OfGetDataTable(sbSql.ToString(), sqlParmList.ToArray());
iChkCnts = dtSdd.Rows.Count;
if (iChkCnts == 0)//新增
{
drSdd = dtSdd.NewRow();
dtSdd.Rows.Add(drSdd);
}
else
{
drSdd = dtSdd.Rows[0];
sddModel.sddmodu = "";
sddModel.sddmodg = "";
sddModel.sddmodd = null;
sddModel.sddsecu = "";
sddModel.sddsecg = "";
}
drSdd["sdd01"] = sddModel.sdd01;
drSdd["sdd02"] = sddModel.sdd02;
drSdd["sdd03"] = sddModel.sdd03;
drSdd["sdd04"] = sddModel.sdd04;
drSdd["sdd05"] = sddModel.sdd05;
drSdd["sdd06"] = sddModel.sdd06;
drSdd["sdd07"] = sddModel.sdd07;
drSdd["sdd08"] = sddModel.sdd08;
drSdd["sdd09"] = sddModel.sdd09;
drSdd["sdd10"] = sddModel.sdd10;
drSdd["sdd11"] = sddModel.sdd11;
drSdd["sdd12"] = sddModel.sdd12;
drSdd["sdd13"] = sddModel.sdd13;
drSdd["sdd14"] = sddModel.sdd14;
drSdd["sdd15"] = sddModel.sdd15;
drSdd["sdd16"] = sddModel.sdd16;
drSdd["sdd17"] = sddModel.sdd17;
drSdd["sdd18"] = sddModel.sdd18;
drSdd["sdd19"] = sddModel.sdd19;
drSdd["sdd20"] = sddModel.sdd20;
if (iChkCnts == 0) //新增
{
drSdd["sddcreu"] = pLoginInfo.UserNo;
drSdd["sddcreg"] = pLoginInfo.DeptNo;
drSdd["sddcred"] = OfGetToday();
if (OfUpdate(dtSdd) != 1)
{
pErrMsg = "新增產品客戶價格表(sdd_tb)失敗!";
return(false);
}
}
else
{
drSdd["sddmodu"] = pLoginInfo.UserNo;
drSdd["sddmodg"] = pLoginInfo.DeptNo;
drSdd["sddsecu"] = pLoginInfo.UserNo;
drSdd["sddsecg"] = pLoginInfo.GroupNo;
if (OfUpdate(dtSdd) != 1)
{
pErrMsg = "異動產品客戶價格表(sdd_tb)失敗!";
return(false);
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
