/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SPD_FamousMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SPD_Famous(");
strSql.Append("FamousName,Biography,Birth,Death,Scource,FamousSysNo,ChartASC,Country,HomeTown,IsUnknow,Height,AstroThemeID,BirthTmp,Gender)");
strSql.Append(" values (");
strSql.Append("@FamousName,@Biography,@Birth,@Death,@Scource,@FamousSysNo,@ChartASC,@Country,@HomeTown,@IsUnknow,@Height,@AstroThemeID,@BirthTmp,@Gender)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@FamousName", SqlDbType.VarChar, 100),
new SqlParameter("@Biography", SqlDbType.VarChar, 5000),
new SqlParameter("@Birth", SqlDbType.DateTime),
new SqlParameter("@Death", SqlDbType.DateTime),
new SqlParameter("@Scource", SqlDbType.NVarChar, 200),
new SqlParameter("@FamousSysNo", SqlDbType.Int, 4),
new SqlParameter("@ChartASC", SqlDbType.VarChar, 100),
new SqlParameter("@Country", SqlDbType.VarChar, 100),
new SqlParameter("@HomeTown", SqlDbType.VarChar, 100),
new SqlParameter("@IsUnknow", SqlDbType.TinyInt, 1),
new SqlParameter("@Height", SqlDbType.VarChar, 100),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@AstroThemeID", SqlDbType.VarChar, 100),
new SqlParameter("@BirthTmp", SqlDbType.VarChar, 100),
new SqlParameter("@Gender", SqlDbType.TinyInt, 1),
};
if (model.FamousName != AppConst.StringNull)
{
parameters[0].Value = model.FamousName;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.Biography != AppConst.StringNull)
{
parameters[1].Value = model.Biography;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Birth != AppConst.DateTimeNull)
{
parameters[2].Value = model.Birth;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Death != AppConst.DateTimeNull)
{
parameters[3].Value = model.Death;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.Scource != AppConst.StringNull)
{
parameters[4].Value = model.Scource;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.FamousSysNo != AppConst.IntNull)
{
parameters[5].Value = model.FamousSysNo;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.ChartASC != AppConst.StringNull)
{
parameters[6].Value = model.ChartASC;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.Country != AppConst.StringNull)
{
parameters[7].Value = model.Country;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.HomeTown != AppConst.StringNull)
{
parameters[8].Value = model.HomeTown;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.IsUnknow != AppConst.IntNull)
{
parameters[9].Value = model.IsUnknow;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.Height != AppConst.StringNull)
{
parameters[10].Value = model.Height;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.DR != AppConst.IntNull)
{
parameters[11].Value = model.DR;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[12].Value = model.TS;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.AstroThemeID != AppConst.StringNull)
{
parameters[13].Value = model.AstroThemeID;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
if (model.BirthTmp != AppConst.StringNull)
{
parameters[14].Value = model.BirthTmp;
}
else
{
parameters[14].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[14]);
if (model.Gender != AppConst.IntNull)
{
parameters[15].Value = model.Gender;
}
else
{
parameters[15].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[15]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SPD_FamousMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, FamousName, Biography, Birth, Death, Scource, FamousSysNo, ChartASC, Country, HomeTown, IsUnknow, Height, DR, TS, AstroThemeID, BirthTmp, Gender from SPD_Famous");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
SPD_FamousMod model = new SPD_FamousMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.FamousName = ds.Tables[0].Rows[0]["FamousName"].ToString();
model.Biography = ds.Tables[0].Rows[0]["Biography"].ToString();
if (ds.Tables[0].Rows[0]["Birth"].ToString() != "")
{
model.Birth = DateTime.Parse(ds.Tables[0].Rows[0]["Birth"].ToString());
}
if (ds.Tables[0].Rows[0]["Death"].ToString() != "")
{
model.Death = DateTime.Parse(ds.Tables[0].Rows[0]["Death"].ToString());
}
model.Scource = ds.Tables[0].Rows[0]["Scource"].ToString();
if (ds.Tables[0].Rows[0]["FamousSysNo"].ToString() != "")
{
model.FamousSysNo = int.Parse(ds.Tables[0].Rows[0]["FamousSysNo"].ToString());
}
model.ChartASC = ds.Tables[0].Rows[0]["ChartASC"].ToString();
model.Country = ds.Tables[0].Rows[0]["Country"].ToString();
model.HomeTown = ds.Tables[0].Rows[0]["HomeTown"].ToString();
if (ds.Tables[0].Rows[0]["IsUnknow"].ToString() != "")
{
model.IsUnknow = int.Parse(ds.Tables[0].Rows[0]["IsUnknow"].ToString());
}
model.Height = ds.Tables[0].Rows[0]["Height"].ToString();
if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
{
model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
model.AstroThemeID = ds.Tables[0].Rows[0]["AstroThemeID"].ToString();
model.BirthTmp = ds.Tables[0].Rows[0]["BirthTmp"].ToString();
if (ds.Tables[0].Rows[0]["Gender"].ToString() != "")
{
model.Gender = int.Parse(ds.Tables[0].Rows[0]["Gender"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 批量导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Unnamed2_Click(object sender, EventArgs e)
{
using (SQLData m_data = new SQLData())
{
for (int i = 16831; i < 40965; i++)
{
DataRow m_dr = m_data.CmdtoDataRow("select * from [SPD_Famous] where sysno =" + i);
if (m_dr["Name"].ToString() == "" || m_dr["Biography"].ToString() == "" || m_dr["Biography"].ToString() == "SameNameError")
{
continue;
}
SYS_FamousMod m_famous = new SYS_FamousMod();
if (m_dr["FamousSysNo"].ToString() != "")
{
m_famous = SYS_FamousBll.GetInstance().GetModel(int.Parse(m_dr["FamousSysNo"].ToString()));
m_famous.Photo = m_dr["photo"].ToString();
SYS_FamousBll.GetInstance().Update(m_famous);
//Console.WriteLine(m_dr["sysno"] + " update ");
continue;
}
DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_dr["HomeTown"].ToString().Split(new char[] { '(', ',' })[0].Trim());
if (!CommonTools.IsDataTableNoRow(m_area))
{
m_famous.HomeTown = int.Parse(m_area.Rows[0]["SysNo3"].ToString());
}
string[] tmp = m_dr["BirthTmp"].ToString().Split(new char[] { '-', ' ', ':' });
int month = 0;
int day = 0;
int hour = 0;
int minute = 0;
if (tmp.Length > 6)
{
if (m_dr["BirthTmp"].ToString().StartsWith("-"))
{
m_famous.BirthYear = int.Parse("-" + tmp[1]);
month = int.Parse(tmp[2].Replace("January", "1").Replace("February", "2").Replace("March", "3")
.Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
.Replace("August", "8").Replace("September", "9").Replace("October", "10")
.Replace("November", "11").Replace("December", "12"));
day = int.Parse(tmp[3]);
if (tmp[4] == "12" && tmp[5] == "00" && tmp[6] == "PM")
{
hour = int.Parse(tmp[4]);
m_famous.TimeUnknown = 1;
}
else
{
if (tmp[6] == "PM" && tmp[4] != "12")
{
hour = (int.Parse(tmp[4]) + 12);
}
else
{
hour = int.Parse(tmp[4]);
}
m_famous.TimeUnknown = 0;
}
minute = int.Parse(tmp[5]);
}
}
else
{
m_famous.BirthYear = int.Parse(tmp[0]);
month = int.Parse(tmp[1].Replace("January", "1").Replace("February", "2").Replace("March", "3")
.Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
.Replace("August", "8").Replace("September", "9").Replace("October", "10")
.Replace("November", "11").Replace("December", "12"));
day = int.Parse(tmp[2]);
if (tmp[3] == "12" && tmp[4] == "00" && tmp[5] == "PM")
{
hour = int.Parse(tmp[3]);
m_famous.TimeUnknown = 1;
}
else
{
if (tmp[5] == "PM" && tmp[3] != "12")
{
hour = int.Parse(tmp[3]) + 12;
}
else
{
hour = int.Parse(tmp[3]);
}
m_famous.TimeUnknown = 0;
}
minute = int.Parse(tmp[4]);
}
m_famous.BirthTime = new DateTime(8000, month, day, hour, minute, 0);
m_famous.CateSysNo = 1;
m_famous.CustomerSysNo = 1;
m_famous.Description = m_dr["Biography"].ToString();
m_famous.DR = 0;
m_famous.FullName = m_dr["FamousName"].ToString();
m_famous.Gender = int.Parse(m_dr["Gender"].ToString());
if (m_dr["Height"].ToString() != "")
{
m_famous.Height = int.Parse(m_dr["Height"].ToString().Replace("m", ""));
}
m_famous.IsTop = 0;
m_famous.Name = m_dr["Name"].ToString();
m_famous.Source = "AstroTheme";
m_famous.TS = DateTime.Now;
m_famous.Photo = m_dr["photo"].ToString();
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(i);
m_spider.FamousSysNo = m_famous.SysNo;
SPD_FamousBll.GetInstance().Update(m_spider);
//Console.WriteLine(m_dr["sysno"] + " add ");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SPD_FamousMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SPD_Famous set ");
strSql.Append("FamousName=@FamousName,");
strSql.Append("Biography=@Biography,");
strSql.Append("Birth=@Birth,");
strSql.Append("Death=@Death,");
strSql.Append("Scource=@Scource,");
strSql.Append("FamousSysNo=@FamousSysNo,");
strSql.Append("ChartASC=@ChartASC,");
strSql.Append("Country=@Country,");
strSql.Append("HomeTown=@HomeTown,");
strSql.Append("IsUnknow=@IsUnknow,");
strSql.Append("Height=@Height,");
strSql.Append("DR=@DR,");
strSql.Append("TS=@TS,");
strSql.Append("AstroThemeID=@AstroThemeID,");
strSql.Append("BirthTmp=@BirthTmp,");
strSql.Append("Gender=@Gender");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@FamousName", SqlDbType.VarChar, 100),
new SqlParameter("@Biography", SqlDbType.VarChar, 5000),
new SqlParameter("@Birth", SqlDbType.DateTime),
new SqlParameter("@Death", SqlDbType.DateTime),
new SqlParameter("@Scource", SqlDbType.NVarChar, 200),
new SqlParameter("@FamousSysNo", SqlDbType.Int, 4),
new SqlParameter("@ChartASC", SqlDbType.VarChar, 100),
new SqlParameter("@Country", SqlDbType.VarChar, 100),
new SqlParameter("@HomeTown", SqlDbType.VarChar, 100),
new SqlParameter("@IsUnknow", SqlDbType.TinyInt, 1),
new SqlParameter("@Height", SqlDbType.VarChar, 100),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@TS", SqlDbType.DateTime),
new SqlParameter("@AstroThemeID", SqlDbType.VarChar, 100),
new SqlParameter("@BirthTmp", SqlDbType.VarChar, 100),
new SqlParameter("@Gender", SqlDbType.TinyInt, 1)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.FamousName != AppConst.StringNull)
{
parameters[1].Value = model.FamousName;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Biography != AppConst.StringNull)
{
parameters[2].Value = model.Biography;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Birth != AppConst.DateTimeNull)
{
parameters[3].Value = model.Birth;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.Death != AppConst.DateTimeNull)
{
parameters[4].Value = model.Death;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.Scource != AppConst.StringNull)
{
parameters[5].Value = model.Scource;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.FamousSysNo != AppConst.IntNull)
{
parameters[6].Value = model.FamousSysNo;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.ChartASC != AppConst.StringNull)
{
parameters[7].Value = model.ChartASC;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.Country != AppConst.StringNull)
{
parameters[8].Value = model.Country;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
if (model.HomeTown != AppConst.StringNull)
{
parameters[9].Value = model.HomeTown;
}
else
{
parameters[9].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[9]);
if (model.IsUnknow != AppConst.IntNull)
{
parameters[10].Value = model.IsUnknow;
}
else
{
parameters[10].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[10]);
if (model.Height != AppConst.StringNull)
{
parameters[11].Value = model.Height;
}
else
{
parameters[11].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[11]);
if (model.DR != AppConst.IntNull)
{
parameters[12].Value = model.DR;
}
else
{
parameters[12].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[12]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[13].Value = model.TS;
}
else
{
parameters[13].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[13]);
if (model.AstroThemeID != AppConst.StringNull)
{
parameters[14].Value = model.AstroThemeID;
}
else
{
parameters[14].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[14]);
if (model.BirthTmp != AppConst.StringNull)
{
parameters[15].Value = model.BirthTmp;
}
else
{
parameters[15].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[15]);
if (model.Gender != AppConst.IntNull)
{
parameters[16].Value = model.Gender;
}
else
{
parameters[16].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[16]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SPD_FamousMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SPD_FamousMod model)
{
return dal.Add(model);
}
protected void PrepareForm()
{
#region 项绑定
drpCate.DataSource = SYS_Famous_CategoryBll.GetInstance().GetList();
drpCate.DataTextField = "Name";
drpCate.DataValueField = "SysNo";
drpCate.DataBind();
drpDistrict1.DataSource = SYS_DistrictBll.GetInstance().GetFirstLevel(0);
drpDistrict1.DataTextField = "Name";
drpDistrict1.DataValueField = "SysNo";
drpDistrict1.DataBind();
drpDistrict1.Items.Insert(0, new ListItem("请选择", "0"));
chkTime.DataSource = AppEnum.GetTimeUnknown();
chkTime.DataTextField = "Value";
chkTime.DataValueField = "Key";
chkTime.DataBind();
#endregion
if (type == "ADD")
{
}
else if (type == "EDIT")
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
try
{
SysNo = int.Parse(Request.QueryString["id"]);
SYS_FamousMod m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
txtSysNo.Text = m_famous.SysNo.ToString();
txtName.Text = m_famous.Name;
txtFullName.Text = m_famous.FullName;
txtDesc.Text = m_famous.Description;
txtYear.Text = m_famous.BirthYear.ToString();
txtMonth.Text = m_famous.BirthTime.Month.ToString();
txtDay.Text = m_famous.BirthTime.Day.ToString();
txtHour.Text = m_famous.BirthTime.Hour.ToString();
txtMinute.Text = m_famous.BirthTime.Minute.ToString();
if (m_famous.Height != AppConst.IntNull)
{
txtHeight.Text = m_famous.Height.ToString();
}
chkTime.SelectedIndex = chkTime.Items.IndexOf(chkTime.Items.FindByValue(m_famous.TimeUnknown.ToString()));
drpCate.SelectedIndex = drpCate.Items.IndexOf(drpCate.Items.FindByValue(m_famous.CateSysNo.ToString()));
drpGender.SelectedIndex = drpGender.Items.IndexOf(drpGender.Items.FindByValue(m_famous.Gender.ToString()));
DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_famous.HomeTown);
if (!CommonTools.IsDataTableNoRow(m_area))
{
drpDistrict1.SelectedIndex = drpDistrict1.Items.IndexOf(drpDistrict1.Items.FindByValue(m_area.Rows[0]["SysNo1"].ToString()));
drpDistrict1_SelectedIndexChanged(new object(), new EventArgs());
drpDistrict2.SelectedIndex = drpDistrict2.Items.IndexOf(drpDistrict2.Items.FindByValue(m_area.Rows[0]["SysNo2"].ToString()));
drpDistrict2_SelectedIndexChanged(new object(), new EventArgs());
drpDistrict3.SelectedIndex = drpDistrict3.Items.IndexOf(drpDistrict3.Items.FindByValue(m_area.Rows[0]["SysNo3"].ToString()));
drpDistrict3_SelectedIndexChanged(new object(), new EventArgs());
}
DataTable m_keydt = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
if (!AppCmn.CommonTools.IsDataTableNoRow(m_keydt))
{
for (int i = 0; i < m_keydt.Rows.Count; i++)
{
txtKey.Text += m_keydt.Rows[i]["KeyWords"].ToString() + " ";
}
txtKey.Text = txtKey.Text.Trim();
}
}
catch
{
Response.Redirect("../Error.aspx?msg=");
return;
}
}
}
else if (type == "INPUT")
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
try
{
int spider = int.Parse(Request.QueryString["id"]);
SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
txtSysNo.Text = "自动生成";
txtFullName.Text = m_spider.FamousName;
string[] tmp = m_spider.BirthTmp.Split(new char[] { '-', ' ', ':' });
if (tmp.Length > 6)
{
if (m_spider.BirthTmp.StartsWith("-"))
{
txtYear.Text = "-" + tmp[1];
txtMonth.Text = tmp[2].Replace("January", "1").Replace("February", "2").Replace("March", "3")
.Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
.Replace("August", "8").Replace("September", "9").Replace("October", "10")
.Replace("November", "11").Replace("December", "12");
txtDay.Text = tmp[3];
if (tmp[4] == "12" && tmp[5] == "00" && tmp[6] == "PM")
{
txtHour.Text = tmp[4];
chkTime.SelectedIndex = 0;
}
else
{
if (tmp[6] == "PM")
{
txtHour.Text = (int.Parse(tmp[4]) + 12).ToString();
}
else
{
txtHour.Text = tmp[4];
}
chkTime.SelectedIndex = 1;
}
txtMinute.Text = tmp[5];
}
}
else
{
txtYear.Text = tmp[0];
txtMonth.Text = tmp[1].Replace("January", "1").Replace("February", "2").Replace("March", "3")
.Replace("April", "4").Replace("May", "5").Replace("June", "6").Replace("July", "7")
.Replace("August", "8").Replace("September", "9").Replace("October", "10")
.Replace("November", "11").Replace("December", "12");
txtDay.Text = tmp[2];
if (tmp[3] == "12" && tmp[4] == "00" && tmp[5] == "PM")
{
txtHour.Text = tmp[3];
chkTime.SelectedIndex = 0;
}
else
{
if (tmp[5] == "PM")
{
txtHour.Text = (int.Parse(tmp[3]) + 12).ToString();
}
else
{
txtHour.Text = tmp[3];
}
chkTime.SelectedIndex = 1;
}
txtMinute.Text = tmp[4];
}
txtHeight.Text = m_spider.Height.Replace("m", "");
drpGender.SelectedIndex = drpGender.Items.IndexOf(drpGender.Items.FindByValue(m_spider.Gender.ToString()));
DataTable m_area = SYS_DistrictBll.GetInstance().GetTreeDetail(m_spider.HomeTown.Split(new char[] { '(', ',' })[0].Trim());
if (!CommonTools.IsDataTableNoRow(m_area))
{
drpDistrict1.SelectedIndex = drpDistrict1.Items.IndexOf(drpDistrict1.Items.FindByValue(m_area.Rows[0]["SysNo1"].ToString()));
drpDistrict1_SelectedIndexChanged(new object(), new EventArgs());
drpDistrict2.SelectedIndex = drpDistrict2.Items.IndexOf(drpDistrict2.Items.FindByValue(m_area.Rows[0]["SysNo2"].ToString()));
drpDistrict2_SelectedIndexChanged(new object(), new EventArgs());
drpDistrict3.SelectedIndex = drpDistrict3.Items.IndexOf(drpDistrict3.Items.FindByValue(m_area.Rows[0]["SysNo3"].ToString()));
drpDistrict3_SelectedIndexChanged(new object(), new EventArgs());
}
}
catch { }
}
}
}
protected void Unnamed3_Click(object sender, EventArgs e)
{
string[] keys = this.txtKey.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
DataTable m_keys = new DataTable();
SYS_FamousMod m_famous = new SYS_FamousMod();
if (type == "EDIT")
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
SysNo = int.Parse(Request.QueryString["id"]);
}
m_famous = SYS_FamousBll.GetInstance().GetModel(SysNo);
m_keys = REL_Famous_KeyWordBll.GetInstance().GetFamousList(SysNo);
}
try
{
m_famous.BirthYear = int.Parse(txtYear.Text);
m_famous.BirthTime = new DateTime(AppConst.DateTimeNull.Year, int.Parse(txtMonth.Text), int.Parse(txtDay.Text),
int.Parse(txtHour.Text), int.Parse(txtMinute.Text), 0);
m_famous.CateSysNo = int.Parse(drpCate.SelectedValue);
m_famous.CustomerSysNo = GetSession().AdminEntity.CustomerSysNo;
m_famous.Description = txtDesc.Text;
m_famous.FullName = txtFullName.Text;
m_famous.Gender = int.Parse(drpGender.SelectedValue);
if (txtHeight.Text != AppConst.StringNull)
{
m_famous.Height = int.Parse(txtHeight.Text);
}
if (drpDistrict3.SelectedValue == "0")
{
ltrError.Text = "请选择第三级地区！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
}
m_famous.HomeTown = int.Parse(drpDistrict3.SelectedValue);
m_famous.Name = txtName.Text;
if (type == "INPUT")
{
m_famous.Source = "AstroTheme";
}
else
{
m_famous.Source = "手动添加";
}
m_famous.TimeUnknown = int.Parse(chkTime.SelectedValue);
}
catch
{
ltrError.Text = "输入资料格式有误，请检查！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
return;
}
try
{
if (type == "ADD")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Add", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "EDIT")
{
SYS_FamousBll.GetInstance().Update(m_famous);
REL_Famous_KeyWordBll.GetInstance().RemoveAllKeyByFamous(m_famous.SysNo);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Edit", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
else if (type == "INPUT")
{
m_famous.SysNo = SYS_FamousBll.GetInstance().Add(m_famous);
int spider = int.Parse(Request.QueryString["id"]);
SPD_FamousMod m_spider = SPD_FamousBll.GetInstance().GetModel(spider);
m_spider.FamousSysNo = m_famous.SysNo;
SPD_FamousBll.GetInstance().Update(m_spider);
for (int i = 0; i < keys.Length; i++)
{
SYS_Famous_KeyWordsMod tmp_key = new SYS_Famous_KeyWordsMod();
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().GetSysNoByName(keys[i]);
if (tmp_key.SysNo == AppConst.IntNull)
{
tmp_key.KeyWords = keys[i];
tmp_key.SysNo = SYS_Famous_KeyWordsBll.GetInstance().Add(tmp_key);
}
REL_Famous_KeyWordMod tmp_rel = new REL_Famous_KeyWordMod();
tmp_rel.Famous_SysNo = m_famous.SysNo;
tmp_rel.KeyWord_SysNo = tmp_key.SysNo;
REL_Famous_KeyWordBll.GetInstance().Add(tmp_rel);
}
LogManagement.getInstance().WriteTrace(m_famous.SysNo, "Celebrity.Input", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
ltrNotice.Text = "该记录已保存成功！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('noticediv').style.display='';", true);
}
catch (Exception ex)
{
ltrError.Text = "系统错误，保存失败！";
this.ClientScript.RegisterStartupScript(this.GetType(), "", "document.getElementById('errordiv').style.display='';closeforseconds();", true);
LogManagement.getInstance().WriteException(ex, "Celebrity.Save", "IP:" + Request.UserHostAddress + "|AdminID:" + GetSession().AdminEntity.Username);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SPD_FamousMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SPD_Famous(");
strSql.Append("FamousName,Biography,Birth,Death,Scource,FamousSysNo,ChartASC,Country,HomeTown,IsUnknow,Height,AstroThemeID,BirthTmp,Gender)");
strSql.Append(" values (");
strSql.Append("@FamousName,@Biography,@Birth,@Death,@Scource,@FamousSysNo,@ChartASC,@Country,@HomeTown,@IsUnknow,@Height,@AstroThemeID,@BirthTmp,@Gender)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@FamousName",SqlDbType.VarChar,100),
new SqlParameter("@Biography",SqlDbType.VarChar,5000),
new SqlParameter("@Birth",SqlDbType.DateTime),
new SqlParameter("@Death",SqlDbType.DateTime),
new SqlParameter("@Scource",SqlDbType.NVarChar,200),
new SqlParameter("@FamousSysNo",SqlDbType.Int,4),
new SqlParameter("@ChartASC",SqlDbType.VarChar,100),
new SqlParameter("@Country",SqlDbType.VarChar,100),
new SqlParameter("@HomeTown",SqlDbType.VarChar,100),
new SqlParameter("@IsUnknow",SqlDbType.TinyInt,1),
new SqlParameter("@Height",SqlDbType.VarChar,100),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@AstroThemeID",SqlDbType.VarChar,100),
new SqlParameter("@BirthTmp",SqlDbType.VarChar,100),
new SqlParameter("@Gender",SqlDbType.TinyInt,1),
};
if (model.FamousName != AppConst.StringNull)
parameters[0].Value = model.FamousName;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.Biography != AppConst.StringNull)
parameters[1].Value = model.Biography;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Birth != AppConst.DateTimeNull)
parameters[2].Value = model.Birth;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Death != AppConst.DateTimeNull)
parameters[3].Value = model.Death;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.Scource != AppConst.StringNull)
parameters[4].Value = model.Scource;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.FamousSysNo != AppConst.IntNull)
parameters[5].Value = model.FamousSysNo;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.ChartASC != AppConst.StringNull)
parameters[6].Value = model.ChartASC;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.Country != AppConst.StringNull)
parameters[7].Value = model.Country;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.HomeTown != AppConst.StringNull)
parameters[8].Value = model.HomeTown;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.IsUnknow != AppConst.IntNull)
parameters[9].Value = model.IsUnknow;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.Height != AppConst.StringNull)
parameters[10].Value = model.Height;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.DR != AppConst.IntNull)
parameters[11].Value = model.DR;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.TS != AppConst.DateTimeNull)
parameters[12].Value = model.TS;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
if (model.AstroThemeID != AppConst.StringNull)
parameters[13].Value = model.AstroThemeID;
else
parameters[13].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[13]);
if (model.BirthTmp != AppConst.StringNull)
parameters[14].Value = model.BirthTmp;
else
parameters[14].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[14]);
if (model.Gender != AppConst.IntNull)
parameters[15].Value = model.Gender;
else
parameters[15].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[15]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SPD_FamousMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SPD_Famous set ");
strSql.Append("FamousName=@FamousName,");
strSql.Append("Biography=@Biography,");
strSql.Append("Birth=@Birth,");
strSql.Append("Death=@Death,");
strSql.Append("Scource=@Scource,");
strSql.Append("FamousSysNo=@FamousSysNo,");
strSql.Append("ChartASC=@ChartASC,");
strSql.Append("Country=@Country,");
strSql.Append("HomeTown=@HomeTown,");
strSql.Append("IsUnknow=@IsUnknow,");
strSql.Append("Height=@Height,");
strSql.Append("DR=@DR,");
strSql.Append("TS=@TS,");
strSql.Append("AstroThemeID=@AstroThemeID,");
strSql.Append("BirthTmp=@BirthTmp,");
strSql.Append("Gender=@Gender");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@FamousName",SqlDbType.VarChar,100),
new SqlParameter("@Biography",SqlDbType.VarChar,5000),
new SqlParameter("@Birth",SqlDbType.DateTime),
new SqlParameter("@Death",SqlDbType.DateTime),
new SqlParameter("@Scource",SqlDbType.NVarChar,200),
new SqlParameter("@FamousSysNo",SqlDbType.Int,4),
new SqlParameter("@ChartASC",SqlDbType.VarChar,100),
new SqlParameter("@Country",SqlDbType.VarChar,100),
new SqlParameter("@HomeTown",SqlDbType.VarChar,100),
new SqlParameter("@IsUnknow",SqlDbType.TinyInt,1),
new SqlParameter("@Height",SqlDbType.VarChar,100),
new SqlParameter("@DR",SqlDbType.TinyInt,1),
new SqlParameter("@TS",SqlDbType.DateTime),
new SqlParameter("@AstroThemeID",SqlDbType.VarChar,100),
new SqlParameter("@BirthTmp",SqlDbType.VarChar,100),
new SqlParameter("@Gender",SqlDbType.TinyInt,1)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.FamousName != AppConst.StringNull)
parameters[1].Value = model.FamousName;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Biography != AppConst.StringNull)
parameters[2].Value = model.Biography;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Birth != AppConst.DateTimeNull)
parameters[3].Value = model.Birth;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.Death != AppConst.DateTimeNull)
parameters[4].Value = model.Death;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.Scource != AppConst.StringNull)
parameters[5].Value = model.Scource;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
if (model.FamousSysNo != AppConst.IntNull)
parameters[6].Value = model.FamousSysNo;
else
parameters[6].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[6]);
if (model.ChartASC != AppConst.StringNull)
parameters[7].Value = model.ChartASC;
else
parameters[7].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[7]);
if (model.Country != AppConst.StringNull)
parameters[8].Value = model.Country;
else
parameters[8].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[8]);
if (model.HomeTown != AppConst.StringNull)
parameters[9].Value = model.HomeTown;
else
parameters[9].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[9]);
if (model.IsUnknow != AppConst.IntNull)
parameters[10].Value = model.IsUnknow;
else
parameters[10].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[10]);
if (model.Height != AppConst.StringNull)
parameters[11].Value = model.Height;
else
parameters[11].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[11]);
if (model.DR != AppConst.IntNull)
parameters[12].Value = model.DR;
else
parameters[12].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[12]);
if (model.TS != AppConst.DateTimeNull)
parameters[13].Value = model.TS;
else
parameters[13].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[13]);
if (model.AstroThemeID != AppConst.StringNull)
parameters[14].Value = model.AstroThemeID;
else
parameters[14].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[14]);
if (model.BirthTmp != AppConst.StringNull)
parameters[15].Value = model.BirthTmp;
else
parameters[15].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[15]);
if (model.Gender != AppConst.IntNull)
parameters[16].Value = model.Gender;
else
parameters[16].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[16]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SPD_FamousMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, FamousName, Biography, Birth, Death, Scource, FamousSysNo, ChartASC, Country, HomeTown, IsUnknow, Height, DR, TS, AstroThemeID, BirthTmp, Gender from SPD_Famous");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
SPD_FamousMod model = new SPD_FamousMod();
DataSet ds = SqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "")
{
model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString());
}
model.FamousName = ds.Tables[0].Rows[0]["FamousName"].ToString();
model.Biography = ds.Tables[0].Rows[0]["Biography"].ToString();
if (ds.Tables[0].Rows[0]["Birth"].ToString() != "")
{
model.Birth = DateTime.Parse(ds.Tables[0].Rows[0]["Birth"].ToString());
}
if (ds.Tables[0].Rows[0]["Death"].ToString() != "")
{
model.Death = DateTime.Parse(ds.Tables[0].Rows[0]["Death"].ToString());
}
model.Scource = ds.Tables[0].Rows[0]["Scource"].ToString();
if (ds.Tables[0].Rows[0]["FamousSysNo"].ToString() != "")
{
model.FamousSysNo = int.Parse(ds.Tables[0].Rows[0]["FamousSysNo"].ToString());
}
model.ChartASC = ds.Tables[0].Rows[0]["ChartASC"].ToString();
model.Country = ds.Tables[0].Rows[0]["Country"].ToString();
model.HomeTown = ds.Tables[0].Rows[0]["HomeTown"].ToString();
if (ds.Tables[0].Rows[0]["IsUnknow"].ToString() != "")
{
model.IsUnknow = int.Parse(ds.Tables[0].Rows[0]["IsUnknow"].ToString());
}
model.Height = ds.Tables[0].Rows[0]["Height"].ToString();
if (ds.Tables[0].Rows[0]["DR"].ToString() != "")
{
model.DR = int.Parse(ds.Tables[0].Rows[0]["DR"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
model.AstroThemeID = ds.Tables[0].Rows[0]["AstroThemeID"].ToString();
model.BirthTmp = ds.Tables[0].Rows[0]["BirthTmp"].ToString();
if (ds.Tables[0].Rows[0]["Gender"].ToString() != "")
{
model.Gender = int.Parse(ds.Tables[0].Rows[0]["Gender"].ToString());
}
return model;
}
else
{
return null;
}
}
