private void ShowInfo(int WebSiteID)
{
WebSiteData.WebSite bll = new WebSiteData.WebSite();
WebSiteModel.WebSite model = bll.GetModel(WebSiteID);
this.lblWebSiteID.Text = model.WebSiteID.ToString();
this.txtWebSiteName.Text = model.WebSiteName;
ddlWebStatus.SelectedValue = model.WebStatusID.ToString();
ddlPartner.SelectedValue = model.PartnerID.ToString();
ddlWebSiteType.SelectedValue = model.WebSiteType;
this.txtBackground.Text = model.Background;
ddBrands.SelectedValue = model.BrandsID.ToString();
this.txtTemplate.Text = model.Template;
this.txtTemplatePic.Text = model.TemplatePic;
this.txtLanguage.Text = model.Language;
//设置radio的值
this.txtOwner.SelectedValue = model.Owner.ToString();
this.txtServer.Text = model.Server;
this.txtIPAddress.Text = model.IPAddress;
this.txtPayment.Value = model.Payment;
//this.txtIseffective.Text = model.Iseffective.ToString();
this.txtProgramsType.Text = model.ProgramsType;
//this.txtSortIndex.Text = model.SortIndex.ToString();
//this.txtIshidden.Text = model.Ishidden.ToString();
this.txtAddDate.Text = model.AddDate.ToString();
this.txtOfflineDate.Text = model.OfflineDate.ToString();
this.txtRemark.Value = model.Remark;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebSiteModel.WebSite GetModel(int WebSiteID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select WebSiteID,WebSiteName,WebStatusID,PartnerID,WebSiteType,Background,BrandsID,Template,TemplatePic,Language,Owner,Server,IPAddress,Payment,Iseffective,ProgramsType,SortIndex,Ishidden,AddDate,OfflineDate,Remark from WebSite ");
strSql.Append(" where WebSiteID=@WebSiteID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@WebSiteID", DbType.Int32, 4)
};
parameters[0].Value = WebSiteID;
WebSiteModel.WebSite model = new WebSiteModel.WebSite();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private bool DoEdit(int id)
{
bool result = true;
WebSiteData.WebSite bll = new WebSiteData.WebSite();
//先获取在修改，这样就会覆盖掉model本身的默认字段值，因为有些字段值在编辑页面没有显示
WebSiteModel.WebSite model = bll.GetModel(id);
int WebSiteID = id;
string WebSiteName = this.txtWebSiteName.Text;
int WebStatusID = int.Parse(ddlWebStatus.SelectedValue);
int PartnerID = int.Parse(ddlPartner.SelectedValue);
string WebSiteType = ddlWebSiteType.SelectedValue;
string Background = this.txtBackground.Text;
int BrandsID = int.Parse(ddBrands.SelectedValue);
string Template = this.txtTemplate.Text;
string TemplatePic = this.txtTemplatePic.Text;
string Language = this.txtLanguage.Text;
int Owner = 0;
if (this.txtOwner.SelectedValue == "1")
{
Owner = 1;
}
string Server = this.txtServer.Text;
string IPAddress = this.txtIPAddress.Text;
string Payment = this.txtPayment.Value;
//int Iseffective = int.Parse(this.txtIseffective.Text);
string ProgramsType = this.txtProgramsType.Text;
//int SortIndex = int.Parse(this.txtSortIndex.Text);
//int Ishidden = int.Parse(this.txtIshidden.Text);
DateTime AddDate;
if (Maticsoft.Common.PageValidate.IsDateTime(this.txtAddDate.Text))
{
AddDate = DateTime.Parse(this.txtAddDate.Text);
}
else
{
AddDate = DateTime.Now;
}
DateTime OfflineDate;
if (Maticsoft.Common.PageValidate.IsDateTime(this.txtOfflineDate.Text))
{
OfflineDate = DateTime.Parse(this.txtOfflineDate.Text);
}
else
{
OfflineDate = DateTime.Now;
}
string Remark = this.txtRemark.Value;
model.WebSiteID = WebSiteID;
model.WebSiteName = WebSiteName;
model.WebStatusID = WebStatusID;
model.PartnerID = PartnerID;
model.WebSiteType = WebSiteType;
model.Background = Background;
model.BrandsID = BrandsID;
model.Template = Template;
model.TemplatePic = TemplatePic;
model.Language = Language;
model.Owner = Owner;
model.Server = Server;
model.IPAddress = IPAddress;
model.Payment = Payment;
//model.Iseffective = Iseffective;
model.ProgramsType = ProgramsType;
//model.SortIndex = SortIndex;
//model.Ishidden = Ishidden;
model.AddDate = AddDate;
model.OfflineDate = OfflineDate;
model.Remark = Remark;
if (!bll.Update(model))
{
result = false;
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebSiteModel.WebSite model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WebSite(");
strSql.Append("WebSiteName,WebStatusID,PartnerID,WebSiteType,Background,BrandsID,Template,TemplatePic,Language,Owner,Server,IPAddress,Payment,Iseffective,ProgramsType,SortIndex,Ishidden,AddDate,OfflineDate,Remark)");
strSql.Append(" values (");
strSql.Append("@WebSiteName,@WebStatusID,@PartnerID,@WebSiteType,@Background,@BrandsID,@Template,@TemplatePic,@Language,@Owner,@Server,@IPAddress,@Payment,@Iseffective,@ProgramsType,@SortIndex,@Ishidden,@AddDate,@OfflineDate,@Remark)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@WebSiteName", DbType.String),
new SQLiteParameter("@WebStatusID", DbType.Int32, 8),
new SQLiteParameter("@PartnerID", DbType.Int32, 8),
new SQLiteParameter("@WebSiteType", DbType.String),
new SQLiteParameter("@Background", DbType.String),
new SQLiteParameter("@BrandsID", DbType.Int32, 8),
new SQLiteParameter("@Template", DbType.String),
new SQLiteParameter("@TemplatePic", DbType.String),
new SQLiteParameter("@Language", DbType.String),
new SQLiteParameter("@Owner", DbType.Int32, 8),
new SQLiteParameter("@Server", DbType.String),
new SQLiteParameter("@IPAddress", DbType.String),
new SQLiteParameter("@Payment", DbType.String),
new SQLiteParameter("@Iseffective", DbType.Int32, 8),
new SQLiteParameter("@ProgramsType", DbType.String),
new SQLiteParameter("@SortIndex", DbType.Int32, 8),
new SQLiteParameter("@Ishidden", DbType.Int32, 8),
new SQLiteParameter("@AddDate", DbType.DateTime),
new SQLiteParameter("@OfflineDate", DbType.DateTime),
new SQLiteParameter("@Remark", DbType.String)
};
parameters[0].Value = model.WebSiteName;
parameters[1].Value = model.WebStatusID;
parameters[2].Value = model.PartnerID;
parameters[3].Value = model.WebSiteType;
parameters[4].Value = model.Background;
parameters[5].Value = model.BrandsID;
parameters[6].Value = model.Template;
parameters[7].Value = model.TemplatePic;
parameters[8].Value = model.Language;
parameters[9].Value = model.Owner;
parameters[10].Value = model.Server;
parameters[11].Value = model.IPAddress;
parameters[12].Value = model.Payment;
parameters[13].Value = model.Iseffective;
parameters[14].Value = model.ProgramsType;
parameters[15].Value = model.SortIndex;
parameters[16].Value = model.Ishidden;
parameters[17].Value = model.AddDate;
parameters[18].Value = model.OfflineDate;
parameters[19].Value = model.Remark;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebSiteModel.WebSite DataRowToModel(DataRow row)
{
WebSiteModel.WebSite model = new WebSiteModel.WebSite();
if (row != null)
{
if (row["WebSiteID"] != null && row["WebSiteID"].ToString() != "")
{
model.WebSiteID = int.Parse(row["WebSiteID"].ToString());
}
if (row["WebSiteName"] != null)
{
model.WebSiteName = row["WebSiteName"].ToString();
}
if (row["WebStatusID"] != null && row["WebStatusID"].ToString() != "")
{
model.WebStatusID = int.Parse(row["WebStatusID"].ToString());
}
if (row["PartnerID"] != null && row["PartnerID"].ToString() != "")
{
model.PartnerID = int.Parse(row["PartnerID"].ToString());
}
if (row["WebSiteType"] != null)
{
model.WebSiteType = row["WebSiteType"].ToString();
}
if (row["Background"] != null)
{
model.Background = row["Background"].ToString();
}
if (row["BrandsID"] != null && row["BrandsID"].ToString() != "")
{
model.BrandsID = int.Parse(row["BrandsID"].ToString());
}
if (row["Template"] != null)
{
model.Template = row["Template"].ToString();
}
if (row["TemplatePic"] != null)
{
model.TemplatePic = row["TemplatePic"].ToString();
}
if (row["Language"] != null)
{
model.Language = row["Language"].ToString();
}
if (row["Owner"] != null && row["Owner"].ToString() != "")
{
model.Owner = int.Parse(row["Owner"].ToString());
}
if (row["Server"] != null)
{
model.Server = row["Server"].ToString();
}
if (row["IPAddress"] != null)
{
model.IPAddress = row["IPAddress"].ToString();
}
if (row["Payment"] != null)
{
model.Payment = row["Payment"].ToString();
}
if (row["Iseffective"] != null && row["Iseffective"].ToString() != "")
{
model.Iseffective = int.Parse(row["Iseffective"].ToString());
}
if (row["ProgramsType"] != null)
{
model.ProgramsType = row["ProgramsType"].ToString();
}
if (row["SortIndex"] != null && row["SortIndex"].ToString() != "")
{
model.SortIndex = int.Parse(row["SortIndex"].ToString());
}
if (row["Ishidden"] != null && row["Ishidden"].ToString() != "")
{
model.Ishidden = int.Parse(row["Ishidden"].ToString());
}
if (row["AddDate"] != null && row["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(row["AddDate"].ToString());
}
if (row["OfflineDate"] != null && row["OfflineDate"].ToString() != "")
{
model.OfflineDate = DateTime.Parse(row["OfflineDate"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebSiteModel.WebSite model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebSite set ");
strSql.Append("WebSiteName=@WebSiteName,");
strSql.Append("WebStatusID=@WebStatusID,");
strSql.Append("PartnerID=@PartnerID,");
strSql.Append("WebSiteType=@WebSiteType,");
strSql.Append("Background=@Background,");
strSql.Append("BrandsID=@BrandsID,");
strSql.Append("Template=@Template,");
strSql.Append("TemplatePic=@TemplatePic,");
strSql.Append("Language=@Language,");
strSql.Append("Owner=@Owner,");
strSql.Append("Server=@Server,");
strSql.Append("IPAddress=@IPAddress,");
strSql.Append("Payment=@Payment,");
strSql.Append("Iseffective=@Iseffective,");
strSql.Append("ProgramsType=@ProgramsType,");
strSql.Append("SortIndex=@SortIndex,");
strSql.Append("Ishidden=@Ishidden,");
strSql.Append("AddDate=@AddDate,");
strSql.Append("OfflineDate=@OfflineDate,");
strSql.Append("Remark=@Remark");
strSql.Append(" where WebSiteID=@WebSiteID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@WebSiteName", DbType.String),
new SQLiteParameter("@WebStatusID", DbType.Int32, 8),
new SQLiteParameter("@PartnerID", DbType.Int32, 8),
new SQLiteParameter("@WebSiteType", DbType.String),
new SQLiteParameter("@Background", DbType.String),
new SQLiteParameter("@BrandsID", DbType.Int32, 8),
new SQLiteParameter("@Template", DbType.String),
new SQLiteParameter("@TemplatePic", DbType.String),
new SQLiteParameter("@Language", DbType.String),
new SQLiteParameter("@Owner", DbType.Int32, 8),
new SQLiteParameter("@Server", DbType.String),
new SQLiteParameter("@IPAddress", DbType.String),
new SQLiteParameter("@Payment", DbType.String),
new SQLiteParameter("@Iseffective", DbType.Int32, 8),
new SQLiteParameter("@ProgramsType", DbType.String),
new SQLiteParameter("@SortIndex", DbType.Int32, 8),
new SQLiteParameter("@Ishidden", DbType.Int32, 8),
new SQLiteParameter("@AddDate", DbType.DateTime),
new SQLiteParameter("@OfflineDate", DbType.DateTime),
new SQLiteParameter("@Remark", DbType.String),
new SQLiteParameter("@WebSiteID", DbType.Int32, 8)
};
parameters[0].Value = model.WebSiteName;
parameters[1].Value = model.WebStatusID;
parameters[2].Value = model.PartnerID;
parameters[3].Value = model.WebSiteType;
parameters[4].Value = model.Background;
parameters[5].Value = model.BrandsID;
parameters[6].Value = model.Template;
parameters[7].Value = model.TemplatePic;
parameters[8].Value = model.Language;
parameters[9].Value = model.Owner;
parameters[10].Value = model.Server;
parameters[11].Value = model.IPAddress;
parameters[12].Value = model.Payment;
parameters[13].Value = model.Iseffective;
parameters[14].Value = model.ProgramsType;
parameters[15].Value = model.SortIndex;
parameters[16].Value = model.Ishidden;
parameters[17].Value = model.AddDate;
parameters[18].Value = model.OfflineDate;
parameters[19].Value = model.Remark;
parameters[20].Value = model.WebSiteID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
