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; } }