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