/// <summary>
/// 获取数字字典名称
/// </summary>
/// <param name="id">主键ID</param>
/// <returns></returns>
public string GetDic(object id)
{
string str;
Mod_TS_DIC mod = ts_dic.GetModel(id.ToString());
str = mod.C_DETAILNAME;
return(str);
}
private void GetArea()
{
#region //需求区域
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropneedarea.DataSource = dt;
dropneedarea.DataTextField = "C_DETAILNAME";
dropneedarea.DataValueField = "C_DETAILNAME";
dropneedarea.DataBind();
}
else
{
dropneedarea.DataSource = null;
dropneedarea.DataBind();
}
#endregion
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
string dept = ts_user.GetDept(vUser.Account);
dropneedarea.SelectedIndex = dropneedarea.Items.IndexOf(dropneedarea.Items.FindByText(dept));
#region //线材库区域
DataTable dtxcarea = tmo_order.GetXCAREA().Tables[0];
if (dtxcarea.Rows.Count > 0)
{
dropsalearea.DataSource = dtxcarea;
dropsalearea.DataTextField = "C_SALE_AREA";
dropsalearea.DataValueField = "C_SALE_AREA";
dropsalearea.DataBind();
dropsalearea.Items.Insert(0, new ListItem("全部区域", "-1"));//
}
else
{
dropsalearea.DataSource = null;
dropsalearea.DataBind();
}
#endregion
#region //质量
DataTable dtzl = tmo_order.GetXC_JUDGE_LEV_ZH("").Tables[0];
if (dtzl.Rows.Count > 0)
{
dropzldj.DataSource = dtzl;
dropzldj.DataTextField = "C_JUDGE_LEV_ZH";
dropzldj.DataValueField = "C_JUDGE_LEV_ZH";
dropzldj.DataBind();
dropzldj.Items.Insert(0, new ListItem("全部质量", ""));
}
#endregion
}
/// <summary>
/// 获取数字字典
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
private DataTable GetData(string code)
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = code;
DataTable dt = ts_dic.GetList(mod).Tables[0];
return(dt);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_DIC DataRowToModel(DataRow row)
{
Mod_TS_DIC model = new Mod_TS_DIC();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_TYPECODE"] != null)
{
model.C_TYPECODE = row["C_TYPECODE"].ToString();
}
if (row["C_TYPENAME"] != null)
{
model.C_TYPENAME = row["C_TYPENAME"].ToString();
}
if (row["C_DETAILCODE"] != null)
{
model.C_DETAILCODE = row["C_DETAILCODE"].ToString();
}
if (row["C_DETAILNAME"] != null)
{
model.C_DETAILNAME = row["C_DETAILNAME"].ToString();
}
if (row["C_INDEX"] != null && row["C_INDEX"].ToString() != "")
{
model.C_INDEX = decimal.Parse(row["C_INDEX"].ToString());
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["N_ISGPS"] != null && row["N_ISGPS"].ToString() != "")
{
model.N_ISGPS = decimal.Parse(row["N_ISGPS"].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());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TS_DIC model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_DIC set ");
strSql.Append("C_TYPECODE=:C_TYPECODE,");
strSql.Append("C_TYPENAME=:C_TYPENAME,");
strSql.Append("C_DETAILCODE=:C_DETAILCODE,");
strSql.Append("C_DETAILNAME=:C_DETAILNAME,");
strSql.Append("C_INDEX=:C_INDEX,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_ISGPS=:N_ISGPS,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_TYPECODE", OracleDbType.Varchar2, 80),
new OracleParameter(":C_TYPENAME", OracleDbType.Varchar2, 80),
new OracleParameter(":C_DETAILCODE", OracleDbType.Varchar2, 80),
new OracleParameter(":C_DETAILNAME", OracleDbType.Varchar2, 80),
new OracleParameter(":C_INDEX", OracleDbType.Int32, 3),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":N_ISGPS", OracleDbType.Int16, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_TYPECODE;
parameters[1].Value = model.C_TYPENAME;
parameters[2].Value = model.C_DETAILCODE;
parameters[3].Value = model.C_DETAILNAME;
parameters[4].Value = model.C_INDEX;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_ISGPS;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.C_EMP_NAME;
parameters[9].Value = model.D_MOD_DT;
parameters[10].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取数字字典名称
/// </summary>
/// <param name="id">主键ID</param>
/// <returns></returns>
private string GetDic(object id)
{
string str = string.Empty;
if (!string.IsNullOrEmpty(id.ToString()))
{
Mod_TS_DIC mod = ts_dic.GetModel(id.ToString());
str = mod.C_DETAILNAME;
}
return(str);
}
public AjaxResult GetArea([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
#region //数据操作
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(dt);
#endregion
return(result);
}
/// <summary>
/// 获取等级
/// </summary>
/// <param name="code">编码</param>
/// <returns></returns>
private string GetLev(string code)
{
string result = "";
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = code;
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
result = dt.Rows[0]["C_DETAILNAME"].ToString();
}
return(result);
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(Mod_TS_DIC model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5 ");
strSql.Append(" FROM TS_DIC where N_STATUS=1 ");
if (!string.IsNullOrEmpty(model.C_TYPECODE))
{
strSql.Append(" and C_TYPECODE='" + model.C_TYPECODE + "'");
}
if (!string.IsNullOrEmpty(model.C_DETAILCODE))
{
strSql.Append(" and C_DETAILCODE='" + model.C_DETAILCODE + "'");
}
strSql.Append(" order by C_INDEX asc");
return(DbHelperOra.Query(strSql.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_DIC model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TS_DIC(");
strSql.Append("C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_TYPECODE,:C_TYPENAME,:C_DETAILCODE,:C_DETAILNAME,:C_INDEX,:N_STATUS,:N_ISGPS,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPECODE", OracleDbType.Varchar2, 80),
new OracleParameter(":C_TYPENAME", OracleDbType.Varchar2, 80),
new OracleParameter(":C_DETAILCODE", OracleDbType.Varchar2, 80),
new OracleParameter(":C_DETAILNAME", OracleDbType.Varchar2, 80),
new OracleParameter(":C_INDEX", OracleDbType.Int32, 3),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":N_ISGPS", OracleDbType.Int16, 1),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_TYPECODE;
parameters[2].Value = model.C_TYPENAME;
parameters[3].Value = model.C_DETAILCODE;
parameters[4].Value = model.C_DETAILNAME;
parameters[5].Value = model.C_INDEX;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.N_ISGPS;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void GetArea()
{
#region //需求区域
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropsalearea.DataSource = dt;
dropsalearea.DataTextField = "C_DETAILNAME";
dropsalearea.DataValueField = "C_DETAILNAME";
dropsalearea.DataBind();
dropsalearea.Items.Insert(0, new ListItem("全部区域", ""));
}
#endregion
}
//加载数据
private void BindData()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ShipVia";
DataTable dt = dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
rptList.DataSource = dt;
rptList.DataBind();
}
else
{
rptList.DataSource = null;
rptList.DataBind();
}
}
private void BindArea()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropArea.DataSource = dt;
dropArea.DataTextField = "C_DETAILNAME";
dropArea.DataValueField = "C_DETAILNAME";
dropArea.DataBind();
}
else
{
dropArea.DataSource = null;
dropArea.DataBind();
}
}
/// <summary>
/// 获取公告分类
/// </summary>
private void GetClass()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "NoticeType";
DataTable dt = dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropClass.DataSource = dt;
dropClass.DataTextField = "C_DETAILNAME";
dropClass.DataValueField = "C_ID";
dropClass.DataBind();
}
else
{
dropClass.DataSource = null;
dropClass.DataBind();
}
}
/// <summary>
/// 合同状态
/// </summary>
private void BindConSate()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ContractStatus";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropState.DataSource = dt;
dropState.DataTextField = "C_DETAILNAME";
dropState.DataValueField = "C_DETAILCODE";
dropState.Items.Insert(0, new ListItem("全部", ""));
}
else
{
dropState.DataSource = null;
dropState.DataBind();
}
}
/// <summary>
/// 业务类型
/// </summary>
private void GetBusinessType()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "BusinessType";
DataTable dt = dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropYeWuType.DataSource = dt;
dropYeWuType.DataTextField = "C_DETAILNAME";
dropYeWuType.DataValueField = "C_DETAILNAME";
dropYeWuType.DataBind();
}
else
{
dropYeWuType.DataSource = null;
dropYeWuType.DataBind();
}
}
/// <summary>
/// 发运方式
/// </summary>
private void GetShipVia()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ShipVia";
DataTable dt = dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropFaYun.DataSource = dt;
dropFaYun.DataTextField = "C_DETAILNAME";
dropFaYun.DataValueField = "C_DETAILNAME";
dropFaYun.DataBind();
}
else
{
dropFaYun.DataSource = null;
dropFaYun.DataBind();
}
}
private void GetArea()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
dtArea = ts_dic.GetList(mod).Tables[0];
if (dtArea.Rows.Count > 0)
{
dropsalearea.DataSource = dtArea;
dropsalearea.DataTextField = "C_DETAILNAME";
dropsalearea.DataValueField = "C_DETAILNAME";
dropsalearea.DataBind();
dropsalearea.Items.Insert(0, new ListItem("全部", ""));//
}
else
{
dropsalearea.DataSource = null;
dropsalearea.DataBind();
dropsalearea.Items.Insert(0, new ListItem("全部", ""));//
}
}
private void BindInfo()
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropneedarea.DataSource = dt;
dropneedarea.DataTextField = "C_DETAILNAME";
dropneedarea.DataValueField = "C_DETAILNAME";
dropneedarea.DataBind();
dropneedarea.Items.Add(new ListItem("空白", ""));
}
else
{
dropneedarea.DataSource = null;
dropneedarea.DataBind();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_DIC GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TS_DIC ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TS_DIC model = new Mod_TS_DIC();
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 btnNo_Click(object sender, EventArgs e)
{
List <Mod_TS_DIC> list = new List <Mod_TS_DIC>();
foreach (RepeaterItem item in rptList.Items)
{
HtmlInputCheckBox chkSelect = (HtmlInputCheckBox)item.FindControl("chkSelect");
Literal ltlnextcheck = (Literal)item.FindControl("ltlnextcheck");
if (chkSelect.Checked)
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_ID = chkSelect.Value;
mod.C_EXTEND2 = ltlnextcheck.Text == "N" ? "Y" : "N";
list.Add(mod);
}
}
if (dic.UpdateAreaCust(list))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('设置成功')", true);
//WebMsg.MessageBox("设置成功");
BindData();
}
}
//发运方式GPS控制
protected void btnOk_Click(object sender, EventArgs e)
{
List <Mod_TS_DIC> list = new List <Mod_TS_DIC>();
foreach (RepeaterItem item in rptList.Items)
{
HtmlInputCheckBox chkSelect = (HtmlInputCheckBox)item.FindControl("chkSelect");
Literal ltlgps = (Literal)item.FindControl("ltlfygps");
if (chkSelect.Checked)
{
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_ID = chkSelect.Value;
mod.N_ISGPS = Convert.ToDecimal(ltlgps.Text == "N" ? "1" : "0");
list.Add(mod);
}
}
if (dic.UpdateAreaGPS(list))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('设置成功')", true);
//WebMsg.MessageBox("设置成功");
BindData();
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(Mod_TS_DIC model)
{
return(dal.GetList(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_DIC model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TS_DIC model)
{
return(dal.Update(model));
}
private void BindInfo()
{
#region //质量
DataTable dtzl = tmo_order.GetXC_JUDGE_LEV_ZH("").Tables[0];
if (dtzl.Rows.Count > 0)
{
dropzldj.DataSource = dtzl;
dropzldj.DataTextField = "C_JUDGE_LEV_ZH";
dropzldj.DataValueField = "C_JUDGE_LEV_ZH";
dropzldj.DataBind();
dropzldj.Items.Insert(0, new ListItem("全部", ""));
}
#endregion
#region //特殊信息
DataTable dtts = tmo_order.GetTS().Tables[0];
if (dtts.Rows.Count > 0)
{
droptsxx.DataSource = dtts;
droptsxx.DataTextField = "C_PCINFO";
droptsxx.DataValueField = "C_PCINFO";
droptsxx.DataBind();
droptsxx.Items.Insert(0, new ListItem("全部", ""));
}
#endregion
#region //线材库区域
DataTable dtxcarea = tmo_order.GetXCAREA("").Tables[0];
if (dtxcarea.Rows.Count > 0)
{
dropsalearea.DataSource = dtxcarea;
dropsalearea.DataTextField = "C_SALE_AREA";
dropsalearea.DataValueField = "C_SALE_AREA";
dropsalearea.DataBind();
dropsalearea.Items.Insert(0, new ListItem("全部", "-1"));//
}
else
{
dropsalearea.DataSource = null;
dropsalearea.DataBind();
}
#endregion
#region //需求区域
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dt = ts_dic.GetList(mod).Tables[0];
if (dt.Rows.Count > 0)
{
dropneedarea.DataSource = dt;
dropneedarea.DataTextField = "C_DETAILNAME";
dropneedarea.DataValueField = "C_DETAILNAME";
dropneedarea.DataBind();
dropneedarea.Items.Add(new ListItem("空白", ""));
}
else
{
dropneedarea.DataSource = null;
dropneedarea.DataBind();
}
#endregion
}
private void GetInfo()
{
try
{
#region //物料名称
DataTable dtMat = tmo_order.GetOrderMat().Tables[0];
if (dtMat.Rows.Count > 0)
{
dropMatName.DataSource = dtMat;
dropMatName.DataTextField = "C_MAT_NAME";
dropMatName.DataValueField = "C_MAT_NAME";
dropMatName.DataBind();
dropMatName.Items.Insert(0, new ListItem("全部", ""));//
}
#endregion
#region /区域
Mod_TS_DIC mod = new Mod_TS_DIC();
mod.C_TYPECODE = "ConArea";
DataTable dtArea = ts_dic.GetList(mod).Tables[0];
if (dtArea.Rows.Count > 0)
{
dropArea.DataSource = dtArea;
dropArea.DataTextField = "C_DETAILNAME";
dropArea.DataValueField = "C_DETAILNAME";
dropArea.DataBind();
dropArea.Items.Insert(0, new ListItem("全部", ""));//
}
#endregion
#region 规格
DataTable dtSpec = tmo_order.GetSpec().Tables[0];
if (dtSpec.Rows.Count > 0)
{
dropSpec.DataSource = dtSpec;
dropSpec.DataValueField = "C_SPEC";
dropSpec.DataTextField = "C_SPEC";
dropSpec.DataBind();
dropSpec.Items.Insert(0, new ListItem("全部规格", ""));
}
#endregion
#region //包装
DataTable dtpack = pack.GetPackList("", "").Tables[0];
if (dtpack.Rows.Count > 0)
{
dropPack.DataSource = dtpack;
dropPack.DataValueField = "C_PACK_TYPE_CODE";
dropPack.DataTextField = "C_PACK_TYPE_CODE";
dropPack.DataBind();
dropPack.Items.Insert(0, new ListItem("全部", ""));
}
#endregion
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}