protected void EBtnSubmit_Click(object sender, EventArgs e)
{
M_Source msource = new M_Source();
B_Source bsource = new B_Source();
msource.Name = TxtName.Text.ToString();
msource.Address = TxtAddress.Text.ToString();
msource.Tel = TxtTel.Text.ToString();
msource.Fax = TxtFax.Text.ToString();
msource.Contacter = TxtContacterName.Text.ToString();
msource.HomePage = TxtHomePage.Text.ToString();
msource.Photo = UpFiles(); //""
msource.ZipCode = DataConverter.CLng(TxtZipCode.Text);
msource.Email = TxtEmail.Text.ToString();
msource.Mail = TxtMail.Text.ToString();
msource.Im = TxtIm.Text.ToString();
msource.LastUseTime = DateTime.Now;
msource.Type = TxtType.Text.ToString();
if (ChkElite.Checked)
{
msource.IsElite = true;
}
else
{
msource.IsElite = false;
}
if (ChkOnTop.Checked)
{
msource.onTop = true;
}
else
{
msource.onTop = false;
}
msource.Intro = ChkPass.Text.ToString();
if (ChkPass.Checked)
{
msource.Passed = true;
}
else
{
msource.Passed = false;
}
if (bsource.Add(msource))
{
Response.Write("<script language=javascript> alert('添加成功！');window.document.location.href='SourceManage.aspx';</script>");
}
}
private void InItModify(int Sid)
{
B_Source bsource = new B_Source();
M_Source msource = bsource.GetSourceByid(Sid);
TxtName.Text = msource.Name;
TxtAddress.Text = msource.Address;
TxtTel.Text = msource.Tel;
TxtFax.Text = msource.Fax;
TxtContacterName.Text = msource.Contacter;
TxtHomePage.Text = msource.HomePage;
txtpic.Text = msource.Photo;
showphoto.Src = "../../" + msource.Photo;
TxtZipCode.Text = msource.ZipCode.ToString();
TxtEmail.Text = msource.Email;
TxtMail.Text = msource.Mail;
TxtIm.Text = msource.Im;
TxtType.Text = "";//来源的分类是否为绑定?
if (msource.IsElite)
{
ChkElite.Checked = true;
}
else
{
ChkElite.Checked = false;
}
if (msource.onTop)
{
ChkOnTop.Checked = true;
}
else
{
ChkOnTop.Checked = false;
}
ChkPass.Text = msource.Intro;
if (msource.Passed)
{
ChkPass.Checked = true;
}
else
{
ChkPass.Checked = false;
}
EBtnModify.Visible = true;
EBtnSubmit.Visible = false;
}
private SqlParameter[] GetParameters(M_Source sourceInfo)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@Type", SqlDbType.VarChar, 50),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Passed", SqlDbType.Bit),
new SqlParameter("@onTop", SqlDbType.Bit),
new SqlParameter("@IsElite", SqlDbType.Bit),
new SqlParameter("@Hits", SqlDbType.Int, 4),
new SqlParameter("@LastUseTime", SqlDbType.DateTime),
new SqlParameter("@Photo", SqlDbType.VarChar, 50),
new SqlParameter("@Intro", SqlDbType.NVarChar, 255),
new SqlParameter("@Address", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Mail", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@ZipCode", SqlDbType.Int),
new SqlParameter("@HomePage", SqlDbType.VarChar, 50),
new SqlParameter("@Im", SqlDbType.VarChar, 50),
new SqlParameter("@ContacterName", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4),
};
parameter[0].Value = sourceInfo.Type;
parameter[1].Value = sourceInfo.Name;
parameter[2].Value = sourceInfo.Passed;
parameter[3].Value = sourceInfo.onTop;
parameter[4].Value = sourceInfo.IsElite;
parameter[5].Value = sourceInfo.Hits;
parameter[6].Value = sourceInfo.LastUseTime;
parameter[7].Value = sourceInfo.Photo;
parameter[8].Value = sourceInfo.Intro;
parameter[9].Value = sourceInfo.Address;
parameter[10].Value = sourceInfo.Tel;
parameter[11].Value = sourceInfo.Fax;
parameter[12].Value = sourceInfo.Mail;
parameter[13].Value = sourceInfo.Email;
parameter[14].Value = sourceInfo.ZipCode;
parameter[15].Value = sourceInfo.HomePage;
parameter[16].Value = sourceInfo.Im;
parameter[17].Value = sourceInfo.Contacter;
parameter[18].Value = sourceInfo.SourceID;
return(parameter);
}
public bool Update(M_Source model)
{
return(UpdateByID(model));
}
public bool Add(M_Source model)
{
return(insert(model) > 0);
}
public int insert(M_Source model)
{
return(Sql.insert(strTableName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_Source model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.SourceID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model)));
}
public bool Update(M_Source SourceInfo)
{
SqlParameter[] cmdParams = GetParameters(SourceInfo);;
return(SqlHelper.ExecuteProc("PR_Source_Update", cmdParams));
}
public bool Update(M_Source SourceInfo)
{
return(SourceMethod.Update(SourceInfo));
}
public bool Add(M_Source sourceInfo)
{
return(SourceMethod.Add(sourceInfo));
}
