protected void Gridview_SupplyInfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Look1")//点击查看联系方式
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Gridview_SupplyInfo.SelectedIndex = row.RowIndex;
label_supplytypeid.Text = Convert.ToString(e.CommandArgument);
Label_SupplyContact_Source.Text = "Gridview数据源";
string sid = e.CommandArgument.ToString();
Guid ls = new Guid(sid);
DataSet ds = pms.SelectPMSupply_One(ls);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
label_SNum.Text = dt.Rows[0][1].ToString();
label_SName.Text = dt.Rows[0][0].ToString();
}
Label_SupplyContact_Source.Text = label_SNum.Text + " " + label_SName.Text;
Panel_PMSupplyContact.Visible = true;
BindGridView_SupplyContact_Gridview(sid);
Panel_PMSupplyContact.Visible = true;
UpdatePanel_PMSupplyContact.Update();
label1_BasicID.Text = sid;
}
if (e.CommandName == "Edit1")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Gridview_SupplyInfo.SelectedIndex = row.RowIndex;
Label_Supply.Text = "编辑供应商";
label_supplytypeid.Text = Convert.ToString(e.CommandArgument);
Guid supplyid = new Guid(Convert.ToString(e.CommandArgument));
DataSet ds = pms.SelectPMSupply_One(supplyid);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
TextBox2.Text = dt.Rows[0][0].ToString();
DropDownList3.SelectedValue = dt.Rows[0][4].ToString();
TextBox1.Text = dt.Rows[0][3].ToString();
TextBox3.Text = dt.Rows[0][5].ToString();
}
Panel_PMSupplyInfo.Visible = true;
UpdatePanel_PMSupplyInfo.Update();
}
if (e.CommandName == "Delete1")//删除供应商
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Gridview_SupplyInfo.SelectedIndex = row.RowIndex;
Guid supplyid = new Guid(Convert.ToString(e.CommandArgument));
pms.DeletePMSupplyInfo(supplyid);
BindGridView_Supplyinfo("");
UpdatePanel_SupplyInfo.Update();
ScriptManager.RegisterClientScriptBlock(UpdatePanel_SupplyInfo, GetType(), "alert", "alert('删除成功！')", true);
return;
}
}
//关闭联系方式表
protected void CanelSupplyContact1(object sender, EventArgs e)
{
try
{
Panel_PMSupplyContact.Visible = false;
Panel_SupplyContactNew.Visible = false;
UpdatePanel_SupplyContactNew.Update();
UpdatePanel_PMSupplyContact.Update();
}
catch (Exception)
{
throw;
}
}
//重置
protected void Button3_Reset(object sender, EventArgs e)
{
try
{
DropDownList1.SelectedValue = "选择供应商类别";
SupplyName.Text = "";
PMSI_SupplyNum.Text = "";
BindGridView_Supplyinfo("");
UpdatePanel_SupplyInfo.Update();
UpdatePanel_PMSupplyContact.Update();
}
catch (Exception)
{
throw;
}
}
//检索
protected void Button1_Sh(object sender, EventArgs e)
{
try
{
string Condition = GetCondition();
BindGridView_Supplyinfo(Condition);
Panel_SupplyInfo.Visible = true;
UpdatePanel_SupplyInfo.Update();
Panel_PMSupplyContact.Visible = false;
UpdatePanel_PMSupplyContact.Update();
Panel_PMSupplyInfo.Visible = false;
UpdatePanel_PMSupplyInfo.Update();
Panel_SupplyContactNew.Visible = false;
UpdatePanel_SupplyContactNew.Update();
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
label_pagestate.Text = Request.QueryString["state"];
string state = label_pagestate.Text;
if (state == "Look")
{
Button8.Visible = false;
Gridview_SupplyInfo.Columns[7].Visible = false;
Gridview_SupplyInfo.Columns[8].Visible = false;
Button2.Visible = false;
GridView_PMSupplyContact.Columns[9].Visible = false;
GridView_PMSupplyContact.Columns[10].Visible = false;
Button8.Enabled = false;
UpdatePanel_SupplySearch.Update();
UpdatePanel_SupplyInfo.Update();
UpdatePanel_PMSupplyContact.Update();
Title = "供应商信息查看";
}
else
{
Title = "供应商信息维护";
}
if (!((Session["UserRole"].ToString().Contains("供应商信息查看")) || (Session["UserRole"].ToString().Contains("供应商信息维护"))))
{
Response.Redirect("~/Default.aspx");
}
DropDownList1.Items.Insert(0, new ListItem("选择供应商类别", "选择供应商类别"));
UpdatePanel_SupplySearch.Visible = true;
BindGridView_Supplyinfo("");
UpdatePanel_SupplyInfo.Update();
UpdatePanel_PMSupplyContact.Update();
}
}
protected void GridView_PMSupplyContact_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit2") //编辑
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView_PMSupplyContact.SelectedIndex = row.RowIndex;
Panel_SupplyContactNew.Visible = true;
label1_PanelSupply.Text = "修改";
UpdatePanel_SupplyContactNew.Update();
label1_BasicID.Text = e.CommandArgument.ToString();
Guid id = new Guid(label1_BasicID.Text.ToString());
DataSet ds = pms.SelectPMSupplyContact_One(id);
DataTable dt = ds.Tables[0];
//this.DropDownList2.SelectedItem.Text = dt.Rows[0][0].ToString();
if (ds.Tables[0].Rows.Count > 0)
{
TextBox_PMSC_Name.Text = dt.Rows[0][2].ToString();
TextBox_PMSC_Position.Text = dt.Rows[0][3].ToString();
TextBox_PMSC_TelephoneNum.Text = dt.Rows[0][4].ToString();
TextBox_PMSC_PhoneNum.Text = dt.Rows[0][5].ToString();
TextBox_PMSC_FaxNum.Text = dt.Rows[0][6].ToString();
TextBox_PMSC_Email.Text = dt.Rows[0][7].ToString();
TextBox_PMSC_QQ.Text = dt.Rows[0][8].ToString();
label1_BasicID.Text = e.CommandArgument.ToString();
}
else
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_SupplyContactNew, GetType(), "alert", "alert('没有数据')", true);
return;
}
DataSet dss = pms.SelectPMSupply_One(id);
DataTable dtt = dss.Tables[0];
if (dtt.Rows.Count > 0)
{
label_SNum.Text = dtt.Rows[0][1].ToString();
label_SName.Text = dtt.Rows[0][0].ToString();
}
Label_Change.Text = label_SNum.Text + " " + label_SName.Text;
}
if (e.CommandName == "Delete2")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView_PMSupplyContact.SelectedIndex = row.RowIndex;
string sid = e.CommandArgument.ToString();
Guid id = new Guid(sid);
pms.DeletePMSupplyContact(id);
// if (this.Label_SupplyContact_Source.Text == "Gridview数据源")
// {
// BindGridView_SupplyContact_Gridview(this.label_supplytypeid.ToString());
//}
// if (this.Label_SupplyContact_Source.Text == "模糊查询数据源")
// {
// BindGridView_Supplyinfo(GetCondition());
// }
// Guid ssd = new Guid(this.label_supplytypeid.Text.ToString());
//pms.SelectPMSupplyContact(ssd );
BindGridView_SupplyContact_Gridview(label_supplytypeid.Text.ToString());
UpdatePanel_PMSupplyContact.Update();
Panel_PMSupplyContact.Visible = true;
ScriptManager.RegisterClientScriptBlock(UpdatePanel_PMSupplyContact, GetType(), "alert", "alert('删除成功！')", true);
return;
}
}
//确认联系方式
protected void ConfirmPMSupplyContact(object sender, EventArgs e)
{
try
{
if (TextBox_PMSC_Name.Text.ToString() == "")
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_SupplyContactNew, GetType(), "alert", "alert('请填写姓名！')", true);
return;
}
else
{
if (TextBox_PMSC_PhoneNum.Text.ToString() == "" && TextBox_PMSC_TelephoneNum.Text.ToString() == "" && TextBox_PMSC_FaxNum.Text.ToString() == "" && TextBox_PMSC_Email.Text.ToString() == "" && TextBox_PMSC_QQ.Text.ToString() == "")
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_SupplyContactNew, GetType(), "alert", "alert('请至少填写一种联系方式！')", true);
return;
}
else
{
string Sname = TextBox_PMSC_Name.Text.ToString();
Guid sid;
string Sphonenum = TextBox_PMSC_PhoneNum.Text.ToString();
string Sposition = TextBox_PMSC_Position.Text.ToString();
string telephonenum = TextBox_PMSC_TelephoneNum.Text.ToString();
string faxnum = TextBox_PMSC_FaxNum.Text.ToString();
string email = TextBox_PMSC_Email.Text.ToString();
string QQ = TextBox_PMSC_QQ.Text.ToString();
if (label1_PanelSupply.Text == "新建")
{
DataSet ds = pms.SelectPMSupplyContact_Same(TextBox_PMSC_Name.Text);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_SupplyContactNew, GetType(), "alert", "alert('该联系人已存在！')", true);
return;
}
Guid idd = new Guid(label1_BasicID.Text.ToString());
pms.InsertPMSupplyContact(idd, Sname, Sposition, telephonenum, Sphonenum, faxnum, email, QQ);
}
if (label1_PanelSupply.Text == "修改")
{
sid = new Guid(label1_BasicID.Text.ToString());
pms.UpdatePMSupplyContact(sid, Sname, Sposition, telephonenum, Sphonenum, faxnum, email, QQ);
}
BindGridView_SupplyContact_Gridview(label_supplytypeid.Text);
UpdatePanel_PMSupplyContact.Update();
Panel_PMSupplyContact.Visible = true;
TextBox_PMSC_Name.Text = "";
TextBox_PMSC_PhoneNum.Text = "";
TextBox_PMSC_Position.Text = "";
TextBox_PMSC_TelephoneNum.Text = "";
TextBox_PMSC_FaxNum.Text = "";
TextBox_PMSC_Email.Text = "";
TextBox_PMSC_QQ.Text = "";
Panel_SupplyContactNew.Visible = false;
}
}
}
catch (Exception)
{
throw;
}
}
