//走访台账记录
protected void btnSave_Click(object sender, EventArgs e)
{
Mod_TMC_CUST_BOOK mod = new Mod_TMC_CUST_BOOK();
mod.D_ZF_DT = Convert.ToDateTime(txtD_ZF_DT.Value);
mod.C_CUST_NAME = txtC_CUST_NAME.Text;
mod.C_AREA = dropArea.SelectedValue;
mod.C_CUST_MANAGE = txtC_CUST_MANAGE.Text;
mod.C_CUST_EMP = txtC_CUST_EMP.Text;
mod.C_CUST_EMP_TEL = txtC_CUST_EMP_TEL.Text;
mod.C_MEETING_CUST = txtC_MEETING_CUST.Text;
mod.C_MEETING_XG = txtC_MEETING_XG.Text;
mod.C_MAIN_CONTENT = txtC_MAIN_CONTENT.Text;
mod.C_NEED_S_Q = txtC_NEED_S_Q.Text;
mod.C_LEAVE_Q = txtC_LEAVE_Q.Text;
mod.C_STL_GRD = txtC_STL_GRD.Text;
mod.C_PRO_USE = txtC_PRO_USE.Text;
mod.C_SITE = txtC_SITE.Text;
mod.C_REMARK = txtC_REMARK.Text;
mod.N_TYPE = Convert.ToDecimal(droptype.SelectedValue);
mod.C_EMPID = ltlempID.Text;
if (tmc_cust_book.Add(mod))
{
WebMsg.MessageBox("保存成功", "Cust_BookAdd.aspx");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_CUST_BOOK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMC_CUST_BOOK(");
strSql.Append("C_ID,D_ZF_DT,C_CUST_NAME,C_AREA,C_CUST_MANAGE,C_CUST_EMP,C_CUST_EMP_TEL,C_MEETING_CUST,C_MEETING_XG,C_MAIN_CONTENT,C_NEED_S_Q,C_LEAVE_Q,C_STL_GRD,C_PRO_USE,C_SITE,C_REMARK,N_TYPE,C_EMPID)");
strSql.Append(" values (");
strSql.Append(":C_ID,:D_ZF_DT,:C_CUST_NAME,:C_AREA,:C_CUST_MANAGE,:C_CUST_EMP,:C_CUST_EMP_TEL,:C_MEETING_CUST,:C_MEETING_XG,:C_MAIN_CONTENT,:C_NEED_S_Q,:C_LEAVE_Q,:C_STL_GRD,:C_PRO_USE,:C_SITE,:C_REMARK,:N_TYPE,:C_EMPID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_ZF_DT", OracleDbType.Date),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 200),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MANAGE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_EMP", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_EMP_TEL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MEETING_CUST", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MEETING_XG", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MAIN_CONTENT", OracleDbType.Varchar2, 500),
new OracleParameter(":C_NEED_S_Q", OracleDbType.Varchar2, 500),
new OracleParameter(":C_LEAVE_Q", OracleDbType.Varchar2, 500),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 300),
new OracleParameter(":C_PRO_USE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_EMPID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.D_ZF_DT;
parameters[2].Value = model.C_CUST_NAME;
parameters[3].Value = model.C_AREA;
parameters[4].Value = model.C_CUST_MANAGE;
parameters[5].Value = model.C_CUST_EMP;
parameters[6].Value = model.C_CUST_EMP_TEL;
parameters[7].Value = model.C_MEETING_CUST;
parameters[8].Value = model.C_MEETING_XG;
parameters[9].Value = model.C_MAIN_CONTENT;
parameters[10].Value = model.C_NEED_S_Q;
parameters[11].Value = model.C_LEAVE_Q;
parameters[12].Value = model.C_STL_GRD;
parameters[13].Value = model.C_PRO_USE;
parameters[14].Value = model.C_SITE;
parameters[15].Value = model.C_REMARK;
parameters[16].Value = model.N_TYPE;
parameters[17].Value = model.C_EMPID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public AjaxResult AddBook([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
#region //接收参数
string zf_dt = Json.zf_dt; //走访日期
string cust_name = Json.cust_name; //客户名称
string area = Json.area; //区域
string cust_manage = Json.cust_manage; //客户经理
string cust_emp = Json.cust_emp; //客户人员
string cust_emp_tel = Json.cust_emp_tel; //客户人员电话
string meeting_cust = Json.meeting_cust; //参会客户名单
string meeting_xg = Json.meeting_xg; //参会邢钢名单
string main_content = Json.main_content; //主要交流内容
string need_s_q = Json.need_s_q; //需解决问题
string leave_q = Json.leave_q; //遗留问题
string stl_grd = Json.stl_grd; //钢种
string pro_use = Json.pro_use; //用途
string site = Json.site; //交流地点
string remark = Json.remark; //备注
string type = Json.type; //0：走访用户，1来访客户
#endregion
#region //数据操作
result.Code = DoResult.Success;
Mod_TS_USER modUser = GetUserID();
Mod_TMC_CUST_BOOK mod = new Mod_TMC_CUST_BOOK();
mod.D_ZF_DT = Convert.ToDateTime(zf_dt);
mod.C_CUST_NAME = cust_name;
mod.C_AREA = area;
mod.C_CUST_MANAGE = cust_manage;
mod.C_CUST_EMP = cust_emp;
mod.C_CUST_EMP_TEL = cust_emp_tel;
mod.C_MEETING_CUST = meeting_cust;
mod.C_MEETING_XG = meeting_xg;
mod.C_MAIN_CONTENT = main_content;
mod.C_NEED_S_Q = need_s_q;
mod.C_LEAVE_Q = leave_q;
mod.C_STL_GRD = stl_grd;
mod.C_PRO_USE = pro_use;
mod.C_SITE = site;
mod.C_REMARK = remark;
mod.N_TYPE = Convert.ToDecimal(type);
mod.C_EMPID = modUser.C_ID;
if (tmc_cust_book.Add(mod))
{
result.Result = "录入成功！";
}
else
{
result.Result = "录入失败！";
}
#endregion
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CUST_BOOK GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,D_ZF_DT,C_CUST_NAME,C_AREA,C_CUST_MANAGE,C_CUST_EMP,C_CUST_EMP_TEL,C_MEETING_CUST,C_MEETING_XG,C_MAIN_CONTENT,C_NEED_S_Q,C_LEAVE_Q,C_STL_GRD,C_PRO_USE,C_SITE,C_REMARK,N_TYPE from TMC_CUST_BOOK ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMC_CUST_BOOK model = new Mod_TMC_CUST_BOOK();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_CUST_BOOK model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_CUST_BOOK model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CUST_BOOK DataRowToModel(DataRow row)
{
Mod_TMC_CUST_BOOK model = new Mod_TMC_CUST_BOOK();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["D_ZF_DT"] != null && row["D_ZF_DT"].ToString() != "")
{
model.D_ZF_DT = DateTime.Parse(row["D_ZF_DT"].ToString());
}
if (row["C_CUST_NAME"] != null)
{
model.C_CUST_NAME = row["C_CUST_NAME"].ToString();
}
if (row["C_AREA"] != null)
{
model.C_AREA = row["C_AREA"].ToString();
}
if (row["C_CUST_MANAGE"] != null)
{
model.C_CUST_MANAGE = row["C_CUST_MANAGE"].ToString();
}
if (row["C_CUST_EMP"] != null)
{
model.C_CUST_EMP = row["C_CUST_EMP"].ToString();
}
if (row["C_CUST_EMP_TEL"] != null)
{
model.C_CUST_EMP_TEL = row["C_CUST_EMP_TEL"].ToString();
}
if (row["C_MEETING_CUST"] != null)
{
model.C_MEETING_CUST = row["C_MEETING_CUST"].ToString();
}
if (row["C_MEETING_XG"] != null)
{
model.C_MEETING_XG = row["C_MEETING_XG"].ToString();
}
if (row["C_MAIN_CONTENT"] != null)
{
model.C_MAIN_CONTENT = row["C_MAIN_CONTENT"].ToString();
}
if (row["C_NEED_S_Q"] != null)
{
model.C_NEED_S_Q = row["C_NEED_S_Q"].ToString();
}
if (row["C_LEAVE_Q"] != null)
{
model.C_LEAVE_Q = row["C_LEAVE_Q"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_PRO_USE"] != null)
{
model.C_PRO_USE = row["C_PRO_USE"].ToString();
}
if (row["C_SITE"] != null)
{
model.C_SITE = row["C_SITE"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["N_TYPE"] != null && row["N_TYPE"].ToString() != "")
{
model.N_TYPE = decimal.Parse(row["N_TYPE"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_CUST_BOOK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMC_CUST_BOOK set ");
strSql.Append("D_ZF_DT=:D_ZF_DT,");
strSql.Append("C_CUST_NAME=:C_CUST_NAME,");
strSql.Append("C_AREA=:C_AREA,");
strSql.Append("C_CUST_MANAGE=:C_CUST_MANAGE,");
strSql.Append("C_CUST_EMP=:C_CUST_EMP,");
strSql.Append("C_CUST_EMP_TEL=:C_CUST_EMP_TEL,");
strSql.Append("C_MEETING_CUST=:C_MEETING_CUST,");
strSql.Append("C_MEETING_XG=:C_MEETING_XG,");
strSql.Append("C_MAIN_CONTENT=:C_MAIN_CONTENT,");
strSql.Append("C_NEED_S_Q=:C_NEED_S_Q,");
strSql.Append("C_LEAVE_Q=:C_LEAVE_Q,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_PRO_USE=:C_PRO_USE,");
strSql.Append("C_SITE=:C_SITE,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("N_TYPE=:N_TYPE");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":D_ZF_DT", OracleDbType.Date),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 200),
new OracleParameter(":C_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_MANAGE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_EMP", OracleDbType.Varchar2, 200),
new OracleParameter(":C_CUST_EMP_TEL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MEETING_CUST", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MEETING_XG", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MAIN_CONTENT", OracleDbType.Varchar2, 500),
new OracleParameter(":C_NEED_S_Q", OracleDbType.Varchar2, 500),
new OracleParameter(":C_LEAVE_Q", OracleDbType.Varchar2, 500),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 300),
new OracleParameter(":C_PRO_USE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_SITE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.D_ZF_DT;
parameters[1].Value = model.C_CUST_NAME;
parameters[2].Value = model.C_AREA;
parameters[3].Value = model.C_CUST_MANAGE;
parameters[4].Value = model.C_CUST_EMP;
parameters[5].Value = model.C_CUST_EMP_TEL;
parameters[6].Value = model.C_MEETING_CUST;
parameters[7].Value = model.C_MEETING_XG;
parameters[8].Value = model.C_MAIN_CONTENT;
parameters[9].Value = model.C_NEED_S_Q;
parameters[10].Value = model.C_LEAVE_Q;
parameters[11].Value = model.C_STL_GRD;
parameters[12].Value = model.C_PRO_USE;
parameters[13].Value = model.C_SITE;
parameters[14].Value = model.C_REMARK;
parameters[15].Value = model.N_TYPE;
parameters[16].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}