public AjaxResult Tech_Prot([FromBody] dynamic Json) { string MatID = Json.MatID; //物料ID #region //数据操作 AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; string[] matList = { "851", "841", "831" }; Mod_TS_USER mod = GetUserID(); Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(mod.C_CUST_ID); Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(MatID); decimal n_type = Convert.ToDecimal(modMat.C_MAT_TYPE); if (!matList.Contains(modMat.C_MAT_GROUP_CODE)) { DataTable dt = tb_std_config.GetCUST_TECH_PROT(modMat.C_STL_GRD, modCust.C_NO).Tables[0]; if (dt.Rows.Count > 0) { result.Result = JsonConvert.SerializeObject(dt); } } #endregion return(result); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //获取用户所属公司名称 var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (vUser != null) { ltluserID.Text = vUser.Id; ltluserName.Text = vUser.Name; Mod_TS_CUSTFILE mod = ts_custfile.GetModel(vUser.CustId); if (mod != null) { ltlCustNo.Text = mod.C_NO; ltlCustName.Text = mod.C_NAME; } GetList(); } else { WebMsg.CheckUserLogin(); } } }
protected void btSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtcustno.Text)) { var mod = new Mod_TS_CUSTFILE() { C_NO = txtcustno.Text, //客户编码 C_EXTEND1 = txtkhh.Text, //开户行 C_TAXPAYERNO = txtsh.Text, //税号 C_EXTEND2 = txtzh.Text, //账号 C_EXTEND3 = txtdz.Text, //地址 C_EXTEND4 = txttel.Text //电话 }; if (ts_custfile.UpdateInfo(mod)) { WebMsg.MessageBox("保存成功"); } } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 检测仓库是否重复 /// </summary> /// <param name="ckcode"></param> /// <returns></returns> private bool getck(string orderID) { bool result = true; Mod_TMO_ORDER mod = tmo_order.GetModel(orderID); #region //客户余额查询 Mod_TS_CUSTFILE modCustInfo = ts_custfile.GetModelCode(mod.C_CUST_NO); DataTable dt = ts_custfile.GetCusetMoney(modCustInfo.C_ID).Tables[0]; if (dt.Rows.Count > 0) { lblcustmoney.Text = modCustInfo.C_NAME + ",余额:" + decimal.Parse(dt.Rows[0]["KHYE"].ToString()).ToString("###,##0.00") + " 更新时间:" + Convert.ToDateTime(dt.Rows[0]["TS"].ToString()).ToString(); } else { lblcustmoney.Text = ""; } #endregion for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox chkOrder = (HtmlInputCheckBox)rptList.Items[i].FindControl("chkOrder"); Literal ltlC_STL_GRD = (Literal)rptList.Items[i].FindControl("ltlC_STL_GRD"); Literal ltlC_SPEC = (Literal)rptList.Items[i].FindControl("ltlC_SPEC"); if (ltlC_STL_GRD.Text == mod.C_STL_GRD && ltlC_SPEC.Text == mod.C_SPEC) { result = false; break; } } return(result); }
/// <summary> /// 获取客户基本信息 /// </summary> /// <param name="CustID">客户ID</param> private void GetCustInfo(string CustID) { Mod_TS_CUSTFILE mod = ts_custfile.GetModel(CustID); if (mod != null) { txtConName.Text = DateTime.Now.ToString("MM.dd") + mod.C_SHORNAME; hidC_CGID.Value = mod.C_NC_M_ID; //收货单位 hidC_OTCID.Value = mod.C_NC_M_ID; //开票单位 txtCust.Value = mod.C_NAME; txtC_CGC.Value = mod.C_NAME; txtC_OTC.Value = mod.C_NAME; txtCustName.Text = mod.C_NAME; //客户名称 hidCustID.Value = mod.C_NC_M_ID; //客户NC主键 hidCustNO.Value = mod.C_NO; //客户编码 ltlCustLEV.Text = mod.N_LEVEL.ToString(); ltlCustType.Text = mod.N_TYPE.ToString() == "1" ? "经销商" : "直销商"; //收货地址 DataTable dtaddr = ts_custaddr.GetAddr(CustID, "", "", "", "1").Tables[0]; if (dtaddr.Rows.Count > 0) { txtAddr.Value = dtaddr.Rows[0]["C_CGAREA"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //获取用户所属公司名称 var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (BaseUser != null) { ltlUserID.Text = BaseUser.Id; ltlUserName.Text = BaseUser.Name; //获取客户信息 if (!string.IsNullOrEmpty(BaseUser.CustId)) { Mod_TS_CUSTFILE mod = ts_custfile.GetModel(BaseUser.CustId); ltlCustNo.Text = mod.C_NO; txtCust.Value = mod.C_NAME; } GetQuestion(); } else { WebMsg.CheckUserLogin(); } } }
public AjaxResult GetOrderZG([FromBody] dynamic Json) { #region //参数 string conNO = Json.conNO; //合同号 string startDate = Json.startDate; //开始时间 string endDate = Json.endDate; //结束时间 #endregion #region //数据操作 AjaxResult result = new AjaxResult(); var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (vUser != null) { Mod_TS_CUSTFILE mod = ts_custfile.GetModel(vUser.CustId); DataTable dt = tmo_order.GetOrderJL(conNO, startDate, endDate, mod.C_NO).Tables[0]; if (dt.Rows.Count > 0) { result.Code = DoResult.Success; result.Result = SerializationHelper.Dtb2Json(dt); } else { result.Code = DoResult.Failed; } } #endregion return(result); }
/// <summary> /// 加载客户默认地址与开票单位 /// </summary> private void BindUserInfo() { var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (BaseUser != null) { //客户档案 Mod_TS_CUSTFILE mod = custfile.GetModel(BaseUser.CustId); if (mod != null) { hidCustNO.Value = mod.C_NO; hidCustName.Value = mod.C_NAME; hidCustLEV.Value = mod.N_LEVEL.ToString(); hidCustType.Value = mod.N_TYPE.ToString() == "1" ? "经销" : "直销"; } //默认收货单位 DataTable dt = custaddr.GetAddrList(BaseUser.CustId, "1").Tables[0]; if (dt.Rows.Count > 0) { txtAddress.Value = dt.Rows[0]["C_CGC"].ToString(); hidAddrID.Value = dt.Rows[0]["C_ID"].ToString(); } //默认开票单位 DataTable dtc = custcompany.GetList(BaseUser.CustId).Tables[0]; if (dtc.Rows.Count > 0) { txtOTCompany.Value = dtc.Rows[0]["C_OTCOMPANY"].ToString(); } } }
/// <summary> /// 客户余额查询 /// </summary> /// <param name="custID">客户档案主键</param> /// <returns></returns> public DataSet GetCusetMoney(string custID) { Mod_TS_CUSTFILE mod = GetModel(custID); string strSql = string.Format("select PK_CUMANDOC,KHYE,TS from xgerp50.so_querykhye where PK_CUMANDOC='{0}' ORDER BY TS DESC", mod.C_NC_M_ID); return(DbHelperNC.Query(strSql)); }
public AjaxResult Material2([FromBody] dynamic Json) { Bll_TB_MATRL_MAIN tb_matrl_main = new Bll_TB_MATRL_MAIN(); Mod_TS_USER modUser = GetUserID(); Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID); AjaxResult result = new AjaxResult(); #region //参数 string MatCode = Json.MatCode; //物料编码 string MatName = Json.MatName; //物料名称 string Stl_Grd = Json.Stl_Grd; //钢种 string Spec = Json.Spec; //规格 string prodKind = Json.prodKind; //大类 string prodName = Json.prodName; //小类 #endregion DataTable dt = new DataTable(); if (prodKind.Contains("商品坯")) { dt = tb_matrl_main.GetCustStlGrd_GP(prodKind, prodName, modCustfile.C_NO, MatCode, Stl_Grd, Spec).Tables[0]; } else { dt = tb_matrl_main.GetCust_StlGrd(prodKind, prodName, modCustfile.C_NO, MatCode, Stl_Grd, Spec).Tables[0]; } result.Code = DoResult.Success; result.Result = JsonConvert.SerializeObject(dt); return(result); }
/// <summary> /// 获取收货单位/开票单位 /// </summary> /// <param name="C_NC_M_ID">NC客商管理档案主键</param> /// <returns></returns> private string GetCust(string C_NC_M_ID) { string str = string.Empty; Mod_TS_CUSTFILE mod = ts_custfile.GetCustModel(C_NC_M_ID); str = mod.C_NAME; return(str); }
/// <summary> /// 获取收货单位/开票单位 /// </summary> /// <param name="C_NC_M_ID">NC客商管理档案主键</param> /// <returns></returns> public string GetCust(string C_NC_M_ID) { string str = string.Empty; Mod_TS_CUSTFILE mod = ts_custfile.GetCustModel(C_NC_M_ID); if (mod != null) { str = mod.C_NAME; } return(str); }
///// <summary> ///// 区域计划量/实际接收订单量 ///// </summary> //private void GetPlanWGT() //{ // DataTable dt = tmb_areaplan.GetPlanWGT().Tables[0]; // if (dt.Rows.Count > 0) // { // for (int i = 0; i < dt.Rows.Count; i++) // { // string[] arr = dt.Rows[i]["wgt"].ToString().Split(':'); // //ltlWGT.Text += "<a href=\"javascript:void(0);\" onclick=\"openWeb3('" + arr[0] + "');\" style=\"margin-left:15px; \">" + dt.Rows[i]["wgt"].ToString() + "</a>"; // ltlWGT.Text += "<li><a href=\"javascript:void(0);\" class=\"a_wgt\" style=\"margin-left:15px; \">" + dt.Rows[i]["wgt"].ToString() + "</a></li>"; // } // } //} /// <summary> /// 获取收货单位/开票单位 /// </summary> /// <param name="C_NC_M_ID">NC客商管理档案主键</param> /// <returns></returns> private string GetCust(string C_NC_M_ID) { string str = string.Empty; if (!string.IsNullOrEmpty(C_NC_M_ID)) { Mod_TS_CUSTFILE mod = ts_custfile.GetCustModel(C_NC_M_ID); str = mod.C_NAME; } return(str); }
public AjaxResult GetMenu([FromBody] dynamic Json) { #region //数据操作 Mod_TS_USER modUser = GetUserID(); Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID); DataTable dt = tb_matrl_main.Get_PROD_KIND(modCustfile.C_NO).Tables[0]; AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; result.Result = SerializationHelper.Dtb2Json(dt); #endregion return(result); }
private void BindInfo() { Mod_TS_CUSTFILE mod = ts_custfile.GetCustInfo(txtcustcode.Text); if (mod != null) { txtcustno.Text = mod.C_NO; txtcustname.Text = mod.C_NAME; txtkhh.Text = mod.C_EXTEND1; txtsh.Text = mod.C_TAXPAYERNO; txtzh.Text = mod.C_EXTEND2; txtdz.Text = mod.C_EXTEND3; txttel.Text = mod.C_EXTEND4; } }
private void BindInfo() { if (!string.IsNullOrEmpty(txtconno.Text)) { #region //合同搜索 Mod_TMO_CON modCon = tmo_con.GetModel(txtconno.Text); if (modCon != null) { droparea.SelectedIndex = droparea.Items.IndexOf(droparea.Items.FindByText(modCon.C_AREA)); txtC_CONNO.Text = modCon.C_CON_NO; txtC_DH_COMPANY.Text = modCon.C_CUSTNAME; txtC_SH_COMPANY.Text = modCon.C_CUSTNAME; txtC_STATION.Text = modCon.C_STATION; txtC_CUSTNO.Text = modCon.C_CUST_NO; Mod_TS_CUSTFILE mod = ts_custfile.GetModelCode(modCon.C_CUST_NO); if (mod != null) { txtC_CUSTNAME.Text = mod.C_NAME; //客户名称 txtC_KH_BANK.Text = mod.C_EXTEND1; //开户行 txtC_TAXNO.Text = mod.C_TAXPAYERNO; //税号 txtC_ACCOUNT.Text = mod.C_EXTEND2; //账号 txtC_ADDRESS.Text = mod.C_EXTEND3; //地址 txtC_TEL.Text = mod.C_EXTEND4; //电话 } } #endregion } if (!string.IsNullOrEmpty(txtcustno.Text)) { #region //客户编码搜索 Mod_TS_CUSTFILE mod = ts_custfile.GetModelCode(txtcustno.Text); if (mod != null) { txtC_CUSTNO.Text = mod.C_NO; txtC_CUSTNAME.Text = mod.C_NAME; //客户名称 txtC_KH_BANK.Text = mod.C_EXTEND1; //开户行 txtC_TAXNO.Text = mod.C_TAXPAYERNO; //税号 txtC_ACCOUNT.Text = mod.C_EXTEND2; //账号 txtC_ADDRESS.Text = mod.C_EXTEND3; //地址 txtC_TEL.Text = mod.C_EXTEND4; //电话 } #endregion } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //获取用户所属公司名称 var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (BaseUser != null) { try { ltlUserID.Text = BaseUser.Id; ltlUserName.Text = BaseUser.Name; //获取客户信息 if (!string.IsNullOrEmpty(BaseUser.CustId)) { Mod_TS_CUSTFILE mod = ts_custfile.GetModel(BaseUser.CustId); ltlCustNo.Text = mod.C_NO; txtcust.Text = mod.C_NAME; } GetQuestion(); if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { ltlID.Text = Request.QueryString["ID"]; Mod_TMC_TECH_CONSULT mod = tmc_tech_consult.GetModel(ltlID.Text); if (mod != null) { dropQuest.SelectedIndex = dropQuest.Items.IndexOf(dropQuest.Items.FindByText(mod.C_QUEST_ID)); txtgrd.Text = mod.C_STL_GRD; txtUseDesc.Value = mod.C_USE_DESC; txtRemark.Value = mod.C_REMARK; horderNO.Value = mod.C_ORDER_NO; } } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } } else { WebMsg.CheckUserLogin(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //获取用户所属公司名称 var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (BaseUser != null) { //初始化日期 txtDate.Value = Convert.ToDateTime(DateTime.Now).ToString("yyy-MM-dd"); DateTime dt = DateTime.Now; txtStart.Value = Convert.ToDateTime(dt).ToString("yyy-MM-dd"); txtEnd.Value = Convert.ToDateTime(dt.AddDays(10)).ToString("yyy-MM-dd"); BindCurrency(); BindContractType(); BindShipVia(); BindArea(); ltlCustName.Text = BaseUser.Name; Mod_TS_CUSTFILE mod = custFile.GetModel(BaseUser.CustId); if (mod != null) { txtCustName.Text = mod.C_NAME; ltlCUST_NO.Text = mod.C_NO; ltlCustLEV.Text = mod.N_LEVEL.ToString() == "1" ? "普通" : "优先"; } if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { txtConNO.Text = Request.QueryString["ID"]; BindConInfo(); } } else { WebMsg.CheckUserLogin(); } } }
public AjaxResult GetMenu3([FromBody] dynamic Json) { #region //参数 string key = Json.key; string key2 = Json.key2; #endregion #region 数据操作 AjaxResult result = new AjaxResult(); Mod_TS_USER modUser = GetUserID(); Mod_TS_CUSTFILE modCustfile = ts_custfile.GetModel(modUser.C_CUST_ID); DataTable dt = tb_matrl_main.Get_PROD_NAME_StlGrd(modCustfile.C_NO, key, key2).Tables[0]; result.Code = DoResult.Success; result.Result = SerializationHelper.Dtb2Json(dt); #endregion return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_CUSTFILE GetCustInfo(string cust) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("select C_ID,C_NC_ID,C_NC_M_ID,N_ISFLAG,C_NO,C_NAME,C_SHORNAME,C_AREATYPE,C_LEGALREPRES,C_AGENT,C_OPERATOR,C_FAX,C_TAXPAYERNO,N_LEVEL,N_STATUS,N_TYPE,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5,C_EMP_ID,C_EMP_NAME,D_MOD_DT,N_ISGPS,C_AREAMMAX from TS_CUSTFILE "); strSql.AppendFormat(" where C_NO='{0}' OR C_NAME='{0}'", cust); Mod_TS_CUSTFILE model = new Mod_TS_CUSTFILE(); DataSet ds = DbHelperOra.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public AjaxResult GetOldOrder([FromBody] dynamic Json) { #region //参数 string ConNo = Json.ConNo; //合同号 string StlGrd = Json.StlGrd; //钢种 string StartTime = Json.StartTime; //签署开始时间 string EndTime = Json.EndTime; //签署结束时间 #endregion #region //数据操作 Mod_TS_USER modUser = GetUserID(); Mod_TS_CUSTFILE mod = ts_custfile.GetModel(modUser.C_CUST_ID); AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; result.Result = SerializationHelper.Dtb2Json(tmo_condetails.GetConOrderList(ConNo, "", StlGrd, StartTime, EndTime, mod.C_NO).Tables[0]); #endregion return(result); }
/// <summary> /// 提交 /// </summary> protected void btnSave_Click(object sender, EventArgs e) { bool result = false; decimal wgt = 0; foreach (RepeaterItem rpt in rptList.Items) { HtmlInputCheckBox chkID = (HtmlInputCheckBox)rpt.FindControl("chkID"); Literal OrderNo = (Literal)rpt.FindControl("ltlOrderNo"); Literal ltlWGT = (Literal)rpt.FindControl("ltlWGT"); if (chkID.Checked) { wgt += Convert.ToDecimal(ltlWGT.Text); Mod_TMO_ORDER_MATCH mod = new Mod_TMO_ORDER_MATCH(); mod.C_ORDER_NO = ltlOrderNo.Text; mod.C_MATCH_ID = chkID.Value; mod.C_OLD_ORDER_NO = OrderNo.Text; mod.C_TYPE = Convert.ToDecimal(ltlType.Text); if (tmo_order_match.Add(mod))//记录 { Mod_TS_CUSTFILE modCust = ts_custfile.GetModel(ltlCustID.Text); if (trc_roll_prodcut.UpdateMatch(chkID.Value, ltlOrderNo.Text, ltlConNo.Text, modCust.C_NO, modCust.C_NAME, "N"))//更新线材自由状态 { result = true; } } } } if (result) { //更新订单匹配量 if (tmo_condetails.UpdateMatch(wgt, ltlOrderNo.Text, Convert.ToInt32(ltlType.Text))) { WebMsg.MessageBox("提交成功"); GetList(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Session["kh"] = null; //获取用户所属公司名称 var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (vUser != null) { DateTime dt = DateTime.Now; Start.Value = dt.AddDays(-(dt.Day) + 1).ToString("yyy-MM-dd"); End.Value = dt.AddMonths(1).AddDays(-(dt.Day)).ToString("yyy-MM-dd"); Mod_TS_CUSTFILE mod = ts_custfile.GetModel(vUser.CustId); if (mod != null) { ltlcustno.Text = mod.C_NO; } } } }
public AjaxResult GetOrderTail([FromBody] dynamic Json) { #region //参数 string ConNO = Json.ConNO; //合同号 string StartDate = Json.StartDate; //开始时间 string EndDate = Json.EndDate; //结束时间 #endregion #region //数据操作 AjaxResult result = new AjaxResult(); Mod_TS_USER modUser = GetUserID(); if (modUser != null) { Mod_TS_CUSTFILE mod = ts_custfile.GetModel(modUser.C_CUST_ID); result.Code = DoResult.Success; result.Result = SerializationHelper.Dtb2Json(tmo_order.GetOrderJL(ConNO, StartDate, EndDate, mod.C_NO).Tables[0]); } #endregion return(result); }
public AjaxResult ConsultAdd([FromBody] dynamic Json) { #region //接收参数 string QuestID = Json.QuestID; //技术问题ID string Stl_Grd = Json.Stl_Grd; //钢种 string UseDesc = Json.UseDesc; //用途及工艺 string Remark = Json.Remark; //问题描述 #endregion #region //数据操作 AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; Mod_TS_USER modUser = GetUserID(); Mod_TS_CUSTFILE modcustfile = ts_custfile.GetModel(modUser.C_CUST_ID); Mod_TMC_TECH_CONSULT mod = new Mod_TMC_TECH_CONSULT(); mod.C_QUEST_ID = QuestID; mod.C_CUST_NAME = modcustfile.C_NAME; mod.C_CUST_CODE = modcustfile.C_NO; mod.C_STL_GRD = Stl_Grd; mod.C_USE_DESC = UseDesc; mod.C_REMARK = Remark; mod.C_EMP_ID = modUser.C_ID; mod.C_EMP_NAME = modUser.C_NAME; if (tmc_tech_consult.Add(mod)) { result.Result = "提交成功"; } else { result.Result = "提交失败"; } #endregion return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_CUSTFILE GetCustModel(string C_NC_M_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_NC_ID,C_NC_M_ID,N_ISFLAG,C_NO,C_NAME,C_SHORNAME,C_AREATYPE,C_LEGALREPRES,C_AGENT,C_OPERATOR,C_FAX,C_TAXPAYERNO,N_LEVEL,N_STATUS,N_TYPE,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5,C_EMP_ID,C_EMP_NAME,D_MOD_DT,N_ISGPS,C_AREAMMAX from TS_CUSTFILE "); strSql.Append(" where C_NC_M_ID=:C_NC_M_ID "); OracleParameter[] parameters = { new OracleParameter(":C_NC_M_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_NC_M_ID; Mod_TS_CUSTFILE model = new Mod_TS_CUSTFILE(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //获取用户所属公司名称 var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (vUser != null) { Session["xm"] = null; DateTime dt = DateTime.Now; txtStart.Value = dt.AddDays(-(dt.Day) + 1).ToString("yyy-MM-dd"); txtEnd.Value = dt.AddMonths(1).AddDays(-(dt.Day)).ToString("yyy-MM-dd"); Mod_TS_CUSTFILE mod = ts_custfile.GetModel(vUser.CustId); if (mod != null) { ltlcustno.Text = mod.C_NO; } if (!string.IsNullOrEmpty(Request.QueryString ["flag"])) { hidflag.Value = Request.QueryString["flag"]; } } } }
/// <summary> /// 加载客户默认地址与开票单位 /// </summary> private void BindUserInfo() { Mod_TMO_CON modCON = tmo_con.GetModel(hidconNo.Value); if (modCON != null) { hidConName.Value = modCON.C_CON_NAME; hidCurrType.Value = modCON.C_CURRENCY_TYPE; hidConArea.Value = modCON.C_CON_AREA; hidShipVia.Value = modCON.C_SHIPVIA; //客户档案 Mod_TS_CUSTFILE mod = custfile.GetCustModel(modCON.C_CUST_NO); if (mod != null) { hidCustNO.Value = mod.C_NO; hidCustName.Value = mod.C_NAME; hidCustLEV.Value = mod.N_LEVEL.ToString(); hidCustType.Value = mod.N_TYPE.ToString() == "1" ? "经销" : "直销"; } //默认收货单位 DataTable dt = custaddr.GetAddrList(mod.C_ID, "1").Tables[0]; if (dt.Rows.Count > 0) { txtAddress.Value = dt.Rows[0]["C_CGC"].ToString(); hidAddrID.Value = dt.Rows[0]["C_ID"].ToString(); } //默认开票单位 DataTable dtc = custcompany.GetList(mod.C_ID).Tables[0]; if (dtc.Rows.Count > 0) { txtOTCompany.Value = dtc.Rows[0]["C_OTCOMPANY"].ToString(); } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TS_CUSTFILE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TS_CUSTFILE("); strSql.Append("C_ID,C_NC_ID,C_NC_M_ID,N_ISFLAG,C_NO,C_NAME,C_SHORNAME,C_AREATYPE,C_LEGALREPRES,C_AGENT,C_OPERATOR,C_FAX,C_TAXPAYERNO,N_LEVEL,N_STATUS,N_TYPE,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5,C_EMP_ID,C_EMP_NAME,D_MOD_DT,N_ISGPS,C_AREAMMAX)"); strSql.Append(" values ("); strSql.Append(":C_ID,:C_NC_ID,:C_NC_M_ID,:N_ISFLAG,:C_NO,:C_NAME,:C_SHORNAME,:C_AREATYPE,:C_LEGALREPRES,:C_AGENT,:C_OPERATOR,:C_FAX,:C_TAXPAYERNO,:N_LEVEL,:N_STATUS,:N_TYPE,:C_EXTEND1,:C_EXTEND2,:C_EXTEND3,:C_EXTEND4,:C_EXTEND5,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:N_ISGPS,:C_AREAMMAX)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_NC_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_NC_M_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_ISFLAG", OracleDbType.Decimal, 1), new OracleParameter(":C_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_NAME", OracleDbType.Varchar2, 200), new OracleParameter(":C_SHORNAME", OracleDbType.Varchar2, 200), new OracleParameter(":C_AREATYPE", OracleDbType.Varchar2, 100), new OracleParameter(":C_LEGALREPRES", OracleDbType.Varchar2, 100), new OracleParameter(":C_AGENT", OracleDbType.Varchar2, 100), new OracleParameter(":C_OPERATOR", OracleDbType.Varchar2, 100), new OracleParameter(":C_FAX", OracleDbType.Varchar2, 100), new OracleParameter(":C_TAXPAYERNO", OracleDbType.Varchar2, 100), new OracleParameter(":N_LEVEL", OracleDbType.Decimal, 2), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 2), new OracleParameter(":N_TYPE", OracleDbType.Decimal, 2), new OracleParameter(":C_EXTEND1", OracleDbType.Varchar2, 500), new OracleParameter(":C_EXTEND2", OracleDbType.Varchar2, 500), new OracleParameter(":C_EXTEND3", OracleDbType.Varchar2, 500), new OracleParameter(":C_EXTEND4", OracleDbType.Varchar2, 500), new OracleParameter(":C_EXTEND5", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":N_ISGPS", OracleDbType.Decimal, 1), new OracleParameter(":C_AREAMMAX", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.C_NC_ID; parameters[2].Value = model.C_NC_M_ID; parameters[3].Value = model.N_ISFLAG; parameters[4].Value = model.C_NO; parameters[5].Value = model.C_NAME; parameters[6].Value = model.C_SHORNAME; parameters[7].Value = model.C_AREATYPE; parameters[8].Value = model.C_LEGALREPRES; parameters[9].Value = model.C_AGENT; parameters[10].Value = model.C_OPERATOR; parameters[11].Value = model.C_FAX; parameters[12].Value = model.C_TAXPAYERNO; parameters[13].Value = model.N_LEVEL; parameters[14].Value = model.N_STATUS; parameters[15].Value = model.N_TYPE; parameters[16].Value = model.C_EXTEND1; parameters[17].Value = model.C_EXTEND2; parameters[18].Value = model.C_EXTEND3; parameters[19].Value = model.C_EXTEND4; parameters[20].Value = model.C_EXTEND5; parameters[21].Value = model.C_EMP_ID; parameters[22].Value = model.C_EMP_NAME; parameters[23].Value = model.D_MOD_DT; parameters[24].Value = model.N_ISGPS; parameters[25].Value = model.C_AREAMMAX; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_CUSTFILE DataRowToModel(DataRow row) { Mod_TS_CUSTFILE model = new Mod_TS_CUSTFILE(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_NC_ID"] != null) { model.C_NC_ID = row["C_NC_ID"].ToString(); } if (row["C_NC_M_ID"] != null) { model.C_NC_M_ID = row["C_NC_M_ID"].ToString(); } if (row["N_ISFLAG"] != null && row["N_ISFLAG"].ToString() != "") { model.N_ISFLAG = decimal.Parse(row["N_ISFLAG"].ToString()); } if (row["C_NO"] != null) { model.C_NO = row["C_NO"].ToString(); } if (row["C_NAME"] != null) { model.C_NAME = row["C_NAME"].ToString(); } if (row["C_SHORNAME"] != null) { model.C_SHORNAME = row["C_SHORNAME"].ToString(); } if (row["C_AREATYPE"] != null) { model.C_AREATYPE = row["C_AREATYPE"].ToString(); } if (row["C_LEGALREPRES"] != null) { model.C_LEGALREPRES = row["C_LEGALREPRES"].ToString(); } if (row["C_AGENT"] != null) { model.C_AGENT = row["C_AGENT"].ToString(); } if (row["C_OPERATOR"] != null) { model.C_OPERATOR = row["C_OPERATOR"].ToString(); } if (row["C_FAX"] != null) { model.C_FAX = row["C_FAX"].ToString(); } if (row["C_TAXPAYERNO"] != null) { model.C_TAXPAYERNO = row["C_TAXPAYERNO"].ToString(); } if (row["N_LEVEL"] != null && row["N_LEVEL"].ToString() != "") { model.N_LEVEL = decimal.Parse(row["N_LEVEL"].ToString()); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["N_TYPE"] != null && row["N_TYPE"].ToString() != "") { model.N_TYPE = decimal.Parse(row["N_TYPE"].ToString()); } if (row["C_EXTEND1"] != null) { model.C_EXTEND1 = row["C_EXTEND1"].ToString(); } if (row["C_EXTEND2"] != null) { model.C_EXTEND2 = row["C_EXTEND2"].ToString(); } if (row["C_EXTEND3"] != null) { model.C_EXTEND3 = row["C_EXTEND3"].ToString(); } if (row["C_EXTEND4"] != null) { model.C_EXTEND4 = row["C_EXTEND4"].ToString(); } if (row["C_EXTEND5"] != null) { model.C_EXTEND5 = row["C_EXTEND5"].ToString(); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["C_EMP_NAME"] != null) { model.C_EMP_NAME = row["C_EMP_NAME"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } if (row["N_ISGPS"] != null && row["N_ISGPS"].ToString() != "") { model.N_ISGPS = decimal.Parse(row["N_ISGPS"].ToString()); } if (row["C_AREAMMAX"] != null) { model.C_AREAMMAX = row["C_AREAMMAX"].ToString(); } } return(model); }