Esempio n. 1
0
    protected void EBtnModify_Click(object sender, EventArgs e)
    {
        M_Source msource = new M_Source();
        B_Source bsource = new B_Source();
        msource.SourceID = Convert.ToInt32(Request.QueryString["SId"].Trim());
        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 = txtpic.Text.ToString();//../../manage/Images/default.gif
        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.Update(msource))
        {
            Response.Write("<script language=javascript> alert('修改成功!');window.document.location.href='SourceManage.aspx';</script>");
        }
    }
Esempio n. 2
0
 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;
 }
Esempio n. 3
0
 public bool Update(M_Source SourceInfo)
 {
     return SourceMethod.Update(SourceInfo);
 }
Esempio n. 4
0
 public bool Add(M_Source sourceInfo)
 {
     return SourceMethod.Add(sourceInfo);
 }
Esempio n. 5
0
 public bool Update(M_Source SourceInfo)
 {
     SqlParameter[] cmdParams = GetParameters(SourceInfo); ;
     return SqlHelper.ExecuteProc("PR_Source_Update", cmdParams);
 }
Esempio n. 6
0
 public bool Add(M_Source SourceInfo)
 {
     string strSql = "PR_Source_Insert";
     SqlParameter[] parameter = GetParameters(SourceInfo);
     return SqlHelper.ExecuteProc(strSql, parameter);
 }
Esempio n. 7
0
 private M_Source GetSourceInfoFromReader(SqlDataReader reader)
 {
     M_Source info = new M_Source();
     info.Type = reader["Type"].ToString();
     info.Name = reader["Name"].ToString();
     info.Passed = DataConverter.CBool(reader["Passed"].ToString());
     info.onTop = DataConverter.CBool(reader["onTop"].ToString());
     info.IsElite = DataConverter.CBool(reader["IsElite"].ToString());
     info.Hits = DataConverter.CLng(reader["Hits"].ToString());
     info.LastUseTime = DataConverter.CDate(reader["LastUseTime"].ToString());
     info.Photo = reader["Photo"].ToString();
     info.Intro = reader["Intro"].ToString();
     info.Address = reader["Address"].ToString();
     info.Tel = reader["Tel"].ToString();
     info.Fax = reader["Fax"].ToString();
     info.Mail = reader["Mail"].ToString();
     info.Email = reader["Email"].ToString();
     info.ZipCode = DataConverter.CLng(reader["ZipCode"].ToString());
     info.HomePage = reader["HomePage"].ToString();
     info.Im =reader["Im"].ToString();
     info.Contacter = reader["Contacter"].ToString();
     reader.Close();
     return info;
 }