/// <summary>
/// 从Sqldatareader读取作者信息
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private M_Author GetAuthorInfoFromReader(SqlDataReader reader)
{
M_Author info = new M_Author();
info.AuthorID = DataConverter.CLng(reader["UserID"].ToString());
info.AuthorType = reader["Type"].ToString();
info.AuthorName = reader["Name"].ToString();
info.AuthorPassed = DataConverter.CBool(reader["Passed"].ToString());
info.AuthoronTop = DataConverter.CBool(reader["onTop"].ToString());
info.AuthorIsElite = DataConverter.CBool(reader["IsElite"].ToString());
info.AuthorHits = DataConverter.CLng(reader["Hits"].ToString());
info.AuthorLastUseTime = DataConverter.CDate(reader["LastUseTime"].ToString());
info.AuthorTemplateID = DataConverter.CLng(reader["TemplateID"].ToString());
info.AuthorPhoto = reader["Photo"].ToString();
info.AuthorIntro = reader["Intro"].ToString();
info.AuthorAddress = reader["Address"].ToString();
info.AuthorTel = reader["Tel"].ToString();
info.AuthorFax = reader["Fax"].ToString();
info.AuthorMail = reader["Mail"].ToString();
info.AuthorEmail = reader["Email"].ToString();
info.AuthorZipCode = DataConverter.CLng(reader["ZipCode"].ToString());
info.AuthorHomePage = reader["HomePage"].ToString();
info.AuthorIm = reader["Im"].ToString();
info.AuthorSex = Convert.ToInt16(reader["Sex"].ToString());//smaallint
info.AuthorBirthDay = DataConverter.CDate(reader["BirthDay"].ToString());
info.AuthorCompany = reader["Company"].ToString();
info.AuthorDepartment = reader["Department"].ToString();
reader.Close();
return(info);
}
/// <returns></returns>
public bool Add(M_Author Authorfo)
{
string strSql = "PR_Author_Add";
SqlParameter[] parameter = GetParameters(Authorfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
private SqlParameter[] GetParameters(M_Author authorInfo)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@UserId", SqlDbType.Int),
//new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Type", 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, 8),
new SqlParameter("@TemplateID", SqlDbType.Int),
new SqlParameter("@Photo", SqlDbType.VarChar, 255),
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("@Sex", SqlDbType.SmallInt),
new SqlParameter("@BirthDay", SqlDbType.DateTime, 8),
new SqlParameter("@Company", SqlDbType.VarChar, 50),
new SqlParameter("@Department", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int)
};
parameter[0].Value = authorInfo.AuthorID;//?
parameter[1].Value = authorInfo.AuthorName;
parameter[2].Value = authorInfo.AuthorType;
parameter[3].Value = authorInfo.AuthorPassed;
parameter[4].Value = authorInfo.AuthoronTop;
parameter[5].Value = authorInfo.AuthorIsElite;
parameter[6].Value = authorInfo.AuthorHits;
parameter[7].Value = authorInfo.AuthorLastUseTime;//?
parameter[8].Value = authorInfo.AuthorTemplateID;
parameter[9].Value = authorInfo.AuthorPhoto;
parameter[10].Value = authorInfo.AuthorIntro;
parameter[11].Value = authorInfo.AuthorAddress;
parameter[12].Value = authorInfo.AuthorTel;
parameter[13].Value = authorInfo.AuthorFax;
parameter[14].Value = authorInfo.AuthorMail;
parameter[15].Value = authorInfo.AuthorEmail;
parameter[16].Value = authorInfo.AuthorZipCode;
parameter[17].Value = authorInfo.AuthorHomePage;
parameter[18].Value = authorInfo.AuthorIm;
parameter[19].Value = authorInfo.AuthorSex;
parameter[20].Value = authorInfo.AuthorBirthDay;
parameter[21].Value = authorInfo.AuthorCompany;
parameter[22].Value = authorInfo.AuthorDepartment;
parameter[23].Value = authorInfo.ID;//?
return(parameter);
}
private void InItModify(int Auid)
{
B_Author bauthor = new B_Author();
M_Author mauthor = bauthor.GetAuthorByid(Auid);
SFile_UP.FileUrl = mauthor.AuthorPhoto;
TxtName.Text = mauthor.AuthorName;
RadlSex.SelectedValue = mauthor.AuthorSex.ToString();
TxtAddress.Text = mauthor.AuthorAddress;
TxtTel.Text = mauthor.AuthorTel;
TxtFax.Text = mauthor.AuthorFax;
TxtCompany.Text = mauthor.AuthorCompany;
TxtDepartment.Text = mauthor.AuthorDepartment;
TxtHomePage.Text = mauthor.AuthorHomePage;
TxtZipCode.Text = mauthor.AuthorZipCode.ToString();
TxtEmail.Text = mauthor.AuthorEmail;
TxtIm.Text = mauthor.AuthorIm;
SetAuthorType(mauthor.AuthorType);//设置作者类别
tbUBday.Value = mauthor.AuthorBirthDay.ToShortDateString();
if (mauthor.AuthorIsElite)
{
ChkElite.Checked = true;
}
else
{
ChkElite.Checked = false;
}
if (mauthor.AuthoronTop)
{
ChkOnTop.Checked = true;
}
else
{
ChkOnTop.Checked = false;
}
TxtIntro.Text = mauthor.AuthorIntro;
if (mauthor.AuthorPassed)
{
ChkPass.Checked = true;
}
EBtnModify.Visible = true;
EBtnSubmit.Visible = false;
}
protected void EBtnModify_Click(object sender, EventArgs e)
{
M_Author mauthor = new M_Author();
B_Author bauthor = new B_Author();
mauthor.ID = Convert.ToInt32(Request.QueryString["AUId"].Trim());
mauthor.AuthorID = 0;
mauthor.AuthorName = TxtName.Text.ToString();
mauthor.AuthorPhoto = UpPhontoFile();
//mauthor. = TxtUserName.Text.ToString(); 会员名没存
mauthor.AuthorSex = Convert.ToInt32(RadlSex.SelectedValue);
mauthor.AuthorLastUseTime = DateTime.Now;
mauthor.AuthorAddress = TxtAddress.Text.ToString();
mauthor.AuthorTel = TxtTel.Text.ToString();
mauthor.AuthorFax = TxtFax.Text.ToString();
mauthor.AuthorCompany = TxtCompany.Text.ToString();
mauthor.AuthorDepartment = TxtDepartment.Text.ToString();
mauthor.AuthorHomePage = TxtHomePage.Text.ToString();
mauthor.AuthorZipCode = DataConverter.CLng(TxtZipCode.Text.ToString());
mauthor.AuthorEmail = TxtEmail.Text.ToString();
mauthor.AuthorMail = TxtMail.Text.ToString();
mauthor.AuthorIm = TxtIm.Text.ToString();
mauthor.AuthorType = GetAuthorType(RadlAuthorType.SelectedIndex);
mauthor.AuthorBirthDay = DataConverter.CDate(tbUBday.Value);
if (ChkElite.Checked)
{
mauthor.AuthorIsElite = true;
}
if (ChkOnTop.Checked)
{
mauthor.AuthoronTop = true;
}
mauthor.AuthorIntro = TxtIntro.Text.ToString();
if (ChkPass.Checked)
{
mauthor.AuthorPassed = true;
}
if (bauthor.Update_Author_ByID(mauthor))
{
Response.Write("<script language=javascript> alert('修改成功！');window.document.location.href='AuthorManage.aspx';</script>");
}
}
public bool Update_Author_ByID(M_Author model)
{
return(UpdateByID(model));
}
public bool Add(M_Author model)
{
return(insert(model) > 0);
}
public int insert(M_Author model)
{
return(Sql.insert(strTableName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_Author model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model)));
}
public bool Update_Author_ByID(M_Author authorInfo)
{
return(dal.Update(authorInfo));
}
public bool Add(M_Author authorInfo)
{
return(dal.Add(authorInfo));
}
public bool Update(M_Author Authorfo)
{
SqlParameter[] cmdParams = GetParameters(Authorfo);;
return(SqlHelper.ExecuteProc("PR_Author_Update", cmdParams));
}
