/// <summary>
/// 增加一条数据
/// </summary>
public int AddSome(tb_Consignor model, List <int> allProIds)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
for (int i = 0; i < allProIds.Count; i++)
{
model.proId = allProIds[i];
Add(model, objCommand);
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(0);
}
return(1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
A_ProInfoService proSer = new A_ProInfoService();
List <A_ProInfo> pros = proSer.GetListArray("");
ddlProType.DataSource = pros;
ddlProType.DataBind();
ddlProType.DataTextField = "pro_Type";
ddlProType.DataValueField = "pro_Id";
if (base.Request["ID"] != null)
{
cbAll.Visible = false;
this.btnAdd.Visible = false;
tb_ConsignorService conSer = new tb_ConsignorService();
tb_Consignor consi = conSer.GetListArray(" con_Id=" + base.Request["ID"])[0];
ddlProType.SelectedItem.Value = consi.proId.ToString();
if (consi.fromTime != null)
{
txtFrom.Text = Convert.ToDateTime(consi.fromTime).ToShortDateString();
}
if (consi.toTime != null)
{
txtTo.Text = Convert.ToDateTime(consi.toTime).ToShortDateString();
}
// txtconsignor.Text = consi.Consignor_Name;
cbYouXiao.Checked = consi.ifYouXiao;
ddlUser.Text = consi.consignor.ToString();
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (this.FormCheck())
{
try
{
tb_Consignor conSer = new tb_Consignor();
conSer.appPer = Convert.ToInt32(Session["currentUserId"]);
// string sql = string.Format("select id from tb_User where loginName='{0}'", ddlUser.SelectedItem.Value);
int userId = Convert.ToInt32(ddlUser.SelectedItem.Value);
conSer.consignor = userId;
conSer.conState = "开启";
if (txtFrom.Text != "")
{
conSer.fromTime = Convert.ToDateTime(txtFrom.Text + " 00:00:00");
}
if (txtTo.Text != "")
{
conSer.toTime = Convert.ToDateTime(txtTo.Text + " 23:59:59");
}
conSer.proId = Convert.ToInt32(ddlProType.SelectedItem.Value);
conSer.ifYouXiao = cbYouXiao.Checked;
conSer.con_Id = Convert.ToInt32(Request["ID"]);
tb_ConsignorService consiSer = new tb_ConsignorService();
consiSer.Update(conSer);
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改成功！');</script>");
}
catch (Exception ex)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "！');</script>");
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.FormCheck())
{
try
{
tb_Consignor conSer = new tb_Consignor();
conSer.appPer = Convert.ToInt32(Session["currentUserId"]);
// string sql = string.Format("select id from tb_User where loginName='{0}'",ddlUser.SelectedItem.Value);
int userId = Convert.ToInt32(ddlUser.SelectedItem.Value);
conSer.consignor = userId;
conSer.conState = "开启";
if (txtFrom.Text != "")
{
conSer.fromTime = Convert.ToDateTime(txtFrom.Text + " 00:00:00");
}
if (txtTo.Text != "")
{
conSer.toTime = Convert.ToDateTime(txtTo.Text + " 23:59:59");
}
conSer.proId = Convert.ToInt32(ddlProType.SelectedItem.Value);
conSer.ifYouXiao = cbYouXiao.Checked;
tb_ConsignorService consiSer = new tb_ConsignorService();
if (cbAll.Checked == false)
{
if (consiSer.Add(conSer) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加成功！');</script>");
txtFrom.Text = "";
txtTo.Text = "";
cbYouXiao.Checked = false;
// txtconsignor.Text = "";
ddlProType.Focus();
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加失败！');</script>");
}
}
else
{
List <int> conList = new List <int>();
for (int i = 0; i < ddlProType.Items.Count; i++)
{
conList.Add(Convert.ToInt32(ddlProType.Items[i].Value));
}
if (consiSer.AddSome(conSer, conList) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加成功！');</script>");
txtFrom.Text = "";
txtTo.Text = "";
cbYouXiao.Checked = false;
//txtconsignor.Text = "";
ddlProType.Focus();
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('添加失败！');</script>");
}
}
}
catch (Exception ex)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "！');</script>");
}
}
}
