protected void BtnUpdate_Click(object sender, EventArgs e)
{
//判断session
if (Session["User"] == null || Session["User"].ToString().Length < 1)
{
Response.Redirect(Request.RawUrl);
}
try
{
//if (ValiEdit())
//{
DBLL.clsContact Contact = new DBLL.clsContact();
DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL();
bool _Result = Contact.update_tb_ContactBynContactID(int.Parse(hfContactListUpdateID.Value), txtsTitle.Text, txtsName.Text, txtsCompanyName.Text, txtsAddress.Text, txtsEmail.Text, txtsFax.Text, txtsPhone.Text, txtsContents.Text, Session["user"].ToString(), DateTime.Now, true, 0, true);
if (_Result == true)
{
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateSuccess");
ShowMsg1.Show();
MultiView1.ActiveViewIndex = 0;
ReBindPageList();
}
else
{
//失败就一条
ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateFail");
ShowMsg1.Show();
}
//}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int nID = 0;
if (Request.QueryString["nID"] != null && int.TryParse(Request.QueryString["nID"].ToString(), out nID) && nID > 0)
{
lblBigtitle.Text = "留言明细";
DBLL.clsContact clContact = new DBLL.clsContact();
DataTable dt = clContact.Select_tb_ContactBynContactID(nID);
if (dt != null && dt.Rows.Count > 0)
{
hfID.Value = dt.Rows[0]["nContactID"].ToString();
txtsName.Text = dt.Rows[0]["sName"].ToString();
txtsCompanyName.Text = dt.Rows[0]["sCompanyName"].ToString();
txtsPhone.Text = dt.Rows[0]["sPhone"].ToString();
txtsPositon.Text = dt.Rows[0]["sPositon"].ToString();
txtsEmail.Text = dt.Rows[0]["sEmail"].ToString();
txtsWeb.Text = dt.Rows[0]["sWeb"].ToString();
txtsContent.Text = dt.Rows[0]["sContents"].ToString();
//绑定数据
}
try
{
bool _Result = clContact.update_tb_ContactBynContactID(nID, true);
}
catch (Exception)
{
throw;
}
}
}
}
public void ReBindPageList()
{
DBLL.clsContact Contact = new DBLL.clsContact();
DataTable dt = new DataTable();
dt = Contact.sp_selectNormalTableOfAllByContact(false);
if (dt != null)
{
ContactList.Merge(dt);
lvContactList.DataSource = ContactList;
lvContactList.DataBind();
}
else
{
lvContactList.DataSource = null;
lvContactList.DataBind();
}
}
//protected void lvContactList_ItemDeleting(object sender, ListViewDeleteEventArgs e)
//{
// DBLL.DBcommon dbcom = new DBLL.DBcommon();
// Label lblnID = (Label)lvContactList.Items[e.ItemIndex].FindControl("lblnLinkID");
// int _nID = 0;
// if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0)
// {
// hfContactUpdateID.Value = _nID.ToString();
// }
// dbcom.sp_DeleteNormalTableByID(int.Parse(hfContactUpdateID.Value), "tb_Link");
// ReBindPageList();
//}
protected void lvContactListt_SelectedIndexChanging(object sender, ListViewSelectEventArgs e)
{
Label lblnID = (Label)lvContactList.Items[e.NewSelectedIndex].FindControl("lblnContactID");
int _nID = 0;
DBLL.clsContact Contact = new DBLL.clsContact();
if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0)
{
MultiView1.ActiveViewIndex = 1;
DataTable dt = Contact.Select_tb_ContactBynContactID(_nID);
txtsTitle.Text = dt.Rows[0]["sTitle"].ToString();
txtsName.Text = dt.Rows[0]["sName"].ToString();
txtsCompanyName.Text = dt.Rows[0]["sCompanyName"].ToString();
txtsAddress.Text = dt.Rows[0]["sAddress"].ToString();
txtsEmail.Text = dt.Rows[0]["sEmail"].ToString();
txtsFax.Text = dt.Rows[0]["sFax"].ToString();
txtsPhone.Text = dt.Rows[0]["sPhone"].ToString();
txtsContents.Text = dt.Rows[0]["sContents"].ToString();
hfContactListUpdateID.Value = _nID.ToString();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
DBLL.clsContact clscon = new DBLL.clsContact();
int result = clscon.insert_tb_Contact("", txtsName.Text, txtsCompanyName.Text, "", txtsEmail.Text, "", txtsPhone.Text, txtsContent.Text, "", DateTime.Now, "", DateTime.Now, true, 0,
false, txtsWeb.Text, txtsJob.Text);
if (txtsVali.Text == base.strValidate)
{
if (result > 0)
{
string xmlfilepath = ConfigurationManager.AppSettings["xmlfilepath"].ToString();
if (Session["languageGlobal"] != null)
{
xmlfilepath = xmlfilepath.Replace("[filename]", Session["languageGlobal"].ToString());
}
else
{
xmlfilepath = xmlfilepath.Replace("[filename]", "cn");
}
clslang langxml = new clslang(xmlfilepath);
langxml.XmlLoad();
ShowMsg1.InnerContent = langxml.getString("leaveMsg", "ShowMsg", "ShowMsgContent");
ShowMsg1.Show();
Clear();
}
else
{
string xmlfilepath = ConfigurationManager.AppSettings["xmlfilepath"].ToString();
if (Session["languageGlobal"] != null)
{
xmlfilepath = xmlfilepath.Replace("[filename]", Session["languageGlobal"].ToString());
}
else
{
xmlfilepath = xmlfilepath.Replace("[filename]", "cn");
}
clslang langxml = new clslang(xmlfilepath);
langxml.XmlLoad();
ShowMsg1.InnerContent = langxml.getString("leaveMsg", "ShowMsg", "ShowMsgFAILContent");
ShowMsg1.Show();
Clear();
}
}
else
{
string xmlfilepath = ConfigurationManager.AppSettings["xmlfilepath"].ToString();
if (Session["languageGlobal"] != null)
{
xmlfilepath = xmlfilepath.Replace("[filename]", Session["languageGlobal"].ToString());
}
else
{
xmlfilepath = xmlfilepath.Replace("[filename]", "cn");
}
clslang langxml = new clslang(xmlfilepath);
langxml.XmlLoad();
ShowMsg1.InnerContent = langxml.getString("leaveMsg", "ShowMsg", "ShowMsgFAILVali");
ShowMsg1.Show();
Clear();
}
}
catch (Exception)
{
throw;
}
}
