// Methods
protected void Button1_Click(object sender, EventArgs e)
{
AstroMod mod = new AstroMod
{
type = PublicValue.AstroType.benming,
birth = new DateTime(int.Parse(this.hfYear.Value), int.Parse(this.hfMonth.Value), int.Parse(this.hfDay.Value), int.Parse(this.hfHour.Value), 0, 0),
position = new LatLng(SYS_DistrictBll.GetInstance().GetModel(0x856)),
IsDayLight = AppEnum.BOOL.False,
zone = -8
};
for (int i = 1; i < 0x15; i++)
{
mod.startsShow.Add(i, "");
}
mod.aspectsShow.Clear();
for (int j = 1; j < 6; j++)
{
mod.aspectsShow.Add(j, 5M);
}
AstroBiz.GetInstance().GetParamters(ref mod);
VenusLoveMod model = new VenusLoveMod
{
BirthTime = mod.birth,
Source = 1,
TS = DateTime.Now,
UserSysNo = QQWeiBoUserBll.GetInstance().GetRecordByName(this.wb_name).SysNo
};
VenusLoveBll.GetInstance().Add(model);
int constellation = 0;
foreach (Star star in mod.Stars)
{
if (star.StarName == PublicValue.AstroStar.Ven)
{
constellation = (int)star.Constellation;
break;
}
}
if (constellation != 0)
{
this.ltrTitle.Text = this.titles[constellation - 1];
this.ltrContext.Text = this.contexts[constellation - 1];
}
this.MultiView1.ActiveViewIndex = 1;
this.ViewState["ele"] = constellation;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VenusLoveMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, BirthTime, Area, Source, UserSysNo, TS from Apps.dbo.VenusLove");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4)
};
parameters[0].Value = SysNo;
VenusLoveMod model = new VenusLoveMod();
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());
}
if (ds.Tables[0].Rows[0]["BirthTime"].ToString() != "")
{
model.BirthTime = DateTime.Parse(ds.Tables[0].Rows[0]["BirthTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Area"].ToString() != "")
{
model.Area = int.Parse(ds.Tables[0].Rows[0]["Area"].ToString());
}
if (ds.Tables[0].Rows[0]["Source"].ToString() != "")
{
model.Source = int.Parse(ds.Tables[0].Rows[0]["Source"].ToString());
}
if (ds.Tables[0].Rows[0]["UserSysNo"].ToString() != "")
{
model.UserSysNo = int.Parse(ds.Tables[0].Rows[0]["UserSysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
return(model);
}
else
{
return(null);
}
}
// Methods
protected void Button1_Click(object sender, EventArgs e)
{
AstroMod mod = new AstroMod
{
type = PublicValue.AstroType.benming,
birth = new DateTime(int.Parse(this.hfYear.Value), int.Parse(this.hfMonth.Value), int.Parse(this.hfDay.Value), int.Parse(this.hfHour.Value), 0, 0),
position = new LatLng(SYS_DistrictBll.GetInstance().GetModel(0x856)),
IsDayLight = AppEnum.BOOL.False,
zone = -8
};
for (int i = 1; i < 0x15; i++)
{
mod.startsShow.Add(i, "");
}
mod.aspectsShow.Clear();
for (int j = 1; j < 6; j++)
{
mod.aspectsShow.Add(j, 5M);
}
AstroBiz.GetInstance().GetParamters(ref mod);
VenusLoveMod model = new VenusLoveMod
{
BirthTime = mod.birth,
Source = 1,
TS = DateTime.Now,
UserSysNo = QQWeiBoUserBll.GetInstance().GetRecordByName(this.wb_name).SysNo
};
VenusLoveBll.GetInstance().Add(model);
int constellation = 0;
foreach (Star star in mod.Stars)
{
if (star.StarName == PublicValue.AstroStar.Ven)
{
constellation = (int)star.Constellation;
break;
}
}
if (constellation != 0)
{
this.ltrTitle.Text = this.titles[constellation - 1];
this.ltrContext.Text = this.contexts[constellation - 1];
}
this.MultiView1.ActiveViewIndex = 1;
this.ViewState["ele"] = constellation;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VenusLoveMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Apps.dbo.VenusLove(");
strSql.Append("BirthTime,Area,Source,UserSysNo,TS)");
strSql.Append(" values (");
strSql.Append("@BirthTime,@Area,@Source,@UserSysNo,@TS)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@BirthTime",SqlDbType.DateTime),
new SqlParameter("@Area",SqlDbType.Int,4),
new SqlParameter("@Source",SqlDbType.Int,4),
new SqlParameter("@UserSysNo",SqlDbType.Int,4),
new SqlParameter("@TS",SqlDbType.DateTime),
};
if (model.BirthTime != AppConst.DateTimeNull)
parameters[0].Value = model.BirthTime;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.Area != AppConst.IntNull)
parameters[1].Value = model.Area;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Source != AppConst.IntNull)
parameters[2].Value = model.Source;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.UserSysNo != AppConst.IntNull)
parameters[3].Value = model.UserSysNo;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.TS != AppConst.DateTimeNull)
parameters[4].Value = model.TS;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(VenusLoveMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Apps.dbo.VenusLove set ");
strSql.Append("BirthTime=@BirthTime,");
strSql.Append("Area=@Area,");
strSql.Append("Source=@Source,");
strSql.Append("UserSysNo=@UserSysNo,");
strSql.Append("TS=@TS");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters = {
new SqlParameter("@SysNo",SqlDbType.Int,4),
new SqlParameter("@BirthTime",SqlDbType.DateTime),
new SqlParameter("@Area",SqlDbType.Int,4),
new SqlParameter("@Source",SqlDbType.Int,4),
new SqlParameter("@UserSysNo",SqlDbType.Int,4),
new SqlParameter("@TS",SqlDbType.DateTime)
};
if (model.SysNo != AppConst.IntNull)
parameters[0].Value = model.SysNo;
else
parameters[0].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[0]);
if (model.BirthTime != AppConst.DateTimeNull)
parameters[1].Value = model.BirthTime;
else
parameters[1].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[1]);
if (model.Area != AppConst.IntNull)
parameters[2].Value = model.Area;
else
parameters[2].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[2]);
if (model.Source != AppConst.IntNull)
parameters[3].Value = model.Source;
else
parameters[3].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[3]);
if (model.UserSysNo != AppConst.IntNull)
parameters[4].Value = model.UserSysNo;
else
parameters[4].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[4]);
if (model.TS != AppConst.DateTimeNull)
parameters[5].Value = model.TS;
else
parameters[5].Value = System.DBNull.Value;
cmd.Parameters.Add(parameters[5]);
return SqlHelper.ExecuteNonQuery(cmd,parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VenusLoveMod GetModel(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SysNo, BirthTime, Area, Source, UserSysNo, TS from Apps.dbo.VenusLove");
strSql.Append(" where SysNo=@SysNo ");
SqlParameter[] parameters = {
new SqlParameter("@SysNo", SqlDbType.Int,4 )
};
parameters[0].Value = SysNo;
VenusLoveMod model = new VenusLoveMod();
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());
}
if (ds.Tables[0].Rows[0]["BirthTime"].ToString() != "")
{
model.BirthTime = DateTime.Parse(ds.Tables[0].Rows[0]["BirthTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Area"].ToString() != "")
{
model.Area = int.Parse(ds.Tables[0].Rows[0]["Area"].ToString());
}
if (ds.Tables[0].Rows[0]["Source"].ToString() != "")
{
model.Source = int.Parse(ds.Tables[0].Rows[0]["Source"].ToString());
}
if (ds.Tables[0].Rows[0]["UserSysNo"].ToString() != "")
{
model.UserSysNo = int.Parse(ds.Tables[0].Rows[0]["UserSysNo"].ToString());
}
if (ds.Tables[0].Rows[0]["TS"].ToString() != "")
{
model.TS = DateTime.Parse(ds.Tables[0].Rows[0]["TS"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VenusLoveMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Apps.dbo.VenusLove(");
strSql.Append("BirthTime,Area,Source,UserSysNo,TS)");
strSql.Append(" values (");
strSql.Append("@BirthTime,@Area,@Source,@UserSysNo,@TS)");
strSql.Append(";select @@IDENTITY");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@BirthTime", SqlDbType.DateTime),
new SqlParameter("@Area", SqlDbType.Int, 4),
new SqlParameter("@Source", SqlDbType.Int, 4),
new SqlParameter("@UserSysNo", SqlDbType.Int, 4),
new SqlParameter("@TS", SqlDbType.DateTime),
};
if (model.BirthTime != AppConst.DateTimeNull)
{
parameters[0].Value = model.BirthTime;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.Area != AppConst.IntNull)
{
parameters[1].Value = model.Area;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Source != AppConst.IntNull)
{
parameters[2].Value = model.Source;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.UserSysNo != AppConst.IntNull)
{
parameters[3].Value = model.UserSysNo;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[4].Value = model.TS;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(VenusLoveMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Apps.dbo.VenusLove set ");
strSql.Append("BirthTime=@BirthTime,");
strSql.Append("Area=@Area,");
strSql.Append("Source=@Source,");
strSql.Append("UserSysNo=@UserSysNo,");
strSql.Append("TS=@TS");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@BirthTime", SqlDbType.DateTime),
new SqlParameter("@Area", SqlDbType.Int, 4),
new SqlParameter("@Source", SqlDbType.Int, 4),
new SqlParameter("@UserSysNo", SqlDbType.Int, 4),
new SqlParameter("@TS", SqlDbType.DateTime)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.BirthTime != AppConst.DateTimeNull)
{
parameters[1].Value = model.BirthTime;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Area != AppConst.IntNull)
{
parameters[2].Value = model.Area;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Source != AppConst.IntNull)
{
parameters[3].Value = model.Source;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.UserSysNo != AppConst.IntNull)
{
parameters[4].Value = model.UserSysNo;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[5].Value = model.TS;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(VenusLoveMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VenusLoveMod model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(VenusLoveMod model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VenusLoveMod model)
{
return dal.Add(model);
}
