protected void Page_Load(object sender, EventArgs e)
{
DataGrid1.DataKeyField = "id";
string ccid = SASRequest.GetString("id");
string mode = SASRequest.GetString("mode");
if (mode != "")
{
if (mode == "del")
{
CardConfigs.DeleteCardConfig(SASRequest.GetQueryInt("id", 0));
}
else
{
if (SASRequest.GetFormString("ccname").Trim() == "" || Utils.IsDateString(SASRequest.GetFormString("createdate")))
{
this.RegisterStartupScript("", "<script type='text/javascript'>alert('名称或有效期输入不合法。');window.location=window.location;</script>");
return;
}
if (ccid == "0")
{
CardConfigInfo cci = new CardConfigInfo();
GetFromData(cci);
CardConfigs.InsertCardConfig(cci);
}
else
{
CardConfigInfo cci = new CardConfigInfo();
cci.id = SASRequest.GetFormInt("id", 0);
GetFromData(cci);
CardConfigs.UpdateCardConfig(cci);
}
}
Response.Redirect(Request.RawUrl, true);
}
else
{
BindDataGrid();
}
}
/// <summary>
/// 获取名片配置列表
/// </summary>
/// <returns></returns>
public static List<CardConfigInfo> GetCardConfigList()
{
List<CardConfigInfo> info = new List<CardConfigInfo>();
IDataReader reader = GetCardConfigData();
while (reader.Read())
{
CardConfigInfo cci = new CardConfigInfo();
cci.id = TypeConverter.ObjectToInt(reader["id"], 0);
cci.ccname = reader["ccname"].ToString().Trim();
cci.tid = TypeConverter.ObjectToInt(reader["tid"], 1);
cci.hasflash = TypeConverter.ObjectToInt(reader["hasflash"], 0);
cci.hasimage = TypeConverter.ObjectToInt(reader["hasimage"], 0);
cci.hasjs = TypeConverter.ObjectToInt(reader["hasjs"], 0);
cci.hassilverlight = TypeConverter.ObjectToInt(reader["hassilverlight"], 0);
cci.showparams = reader["showparams"].ToString().Trim();
cci.createdate = reader["createdate"].ToString();
cci.vailddate = reader["vailddate"].ToString();
info.Add(cci);
}
reader.Close();
return info;
}
/// <summary>
/// 修改名片配置信息
/// </summary>
public void UpdateCardConfig(CardConfigInfo cci)
{
DbParameter[] param = {
DbHelper.MakeInParam("@id",(DbType)SqlDbType.Int,4,cci.id),
DbHelper.MakeInParam("@ccname",(DbType)SqlDbType.NVarChar,50,cci.ccname),
DbHelper.MakeInParam("@tid",(DbType)SqlDbType.Int,4,cci.tid),
DbHelper.MakeInParam("@hasflash",(DbType)SqlDbType.TinyInt, 1, cci.hasflash),
DbHelper.MakeInParam("@hasimage",(DbType)SqlDbType.TinyInt, 1, cci.hasimage),
DbHelper.MakeInParam("@hasjs",(DbType)SqlDbType.TinyInt, 1, cci.hasjs),
DbHelper.MakeInParam("@hassilverlight",(DbType)SqlDbType.TinyInt, 1, cci.hassilverlight),
DbHelper.MakeInParam("@showparams",(DbType)SqlDbType.NText,1,cci.showparams),
DbHelper.MakeInParam("@vailddate",(DbType)SqlDbType.DateTime,8,cci.vailddate)
};
string commandText = String.Format("UPDATE [{0}cardconfig] SET [tid] = @tid,[ccname] = @ccname,[hasflash] = @hasflash,[hasimage] = @hasimage,[hasjs] = @hasjs,[hassilverlight] = @hassilverlight,[showparams] = @showparams,[vailddate] = @vailddate WHERE [id] = @id",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
}
/// <summary>
/// 增加企业名片配置信息
/// </summary>
/// <param name="cci"></param>
public void InsertCardConfig(CardConfigInfo cci)
{
DbParameter[] param = {
DbHelper.MakeInParam("@ccname",(DbType)SqlDbType.NVarChar,50,cci.ccname),
DbHelper.MakeInParam("@tid",(DbType)SqlDbType.Int,4,cci.tid),
DbHelper.MakeInParam("@hasflash",(DbType)SqlDbType.TinyInt, 1, cci.hasflash),
DbHelper.MakeInParam("@hasimage",(DbType)SqlDbType.TinyInt, 1, cci.hasimage),
DbHelper.MakeInParam("@hasjs",(DbType)SqlDbType.TinyInt, 1, cci.hasjs),
DbHelper.MakeInParam("@hassilverlight",(DbType)SqlDbType.TinyInt, 1, cci.hassilverlight),
DbHelper.MakeInParam("@showparams",(DbType)SqlDbType.NText,1,cci.showparams),
DbHelper.MakeInParam("@vailddate",(DbType)SqlDbType.DateTime,8,cci.vailddate)
};
string commandText = String.Format("INSERT INTO [{0}cardconfig] ([tid],[ccname],[hasflash],[hasimage],[hasjs],[hassilverlight],[showparams],[vailddate]) VALUES(@tid,@ccname,@hasflash,@hasimage,@hasjs,@hassilverlight,@showparams,@vailddate)",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
}
/// <summary>
/// 修改名片配置信息
/// </summary>
public static void UpdateCardConfig(CardConfigInfo cci)
{
DatabaseProvider.GetInstance().UpdateCardConfig(cci);
}
/// <summary>
/// 增加企业名片配置信息
/// </summary>
/// <param name="cci"></param>
public static void InsertCardConfig(CardConfigInfo cci)
{
DatabaseProvider.GetInstance().InsertCardConfig(cci);
}
private void GetFromData(CardConfigInfo cci)
{
cci.ccname = SASRequest.GetFormString("ccname");
cci.tid = SASRequest.GetFormInt("tid", 1);
cci.hasflash = SASRequest.GetFormInt("hasflash",0);
cci.hasimage = SASRequest.GetFormInt("hasimage", 0);
cci.hasjs = SASRequest.GetFormInt("hasjs", 0);
cci.hassilverlight = SASRequest.GetFormInt("hassilverlight", 0);
cci.showparams = SASRequest.GetFormString("showparams");
cci.vailddate = SASRequest.GetFormString("vailddate");
}
/// <summary>
/// 修改名片配置信息
/// </summary>
/// <param name="cci"></param>
public static void UpdateCardConfig(CardConfigInfo cci)
{
SAS.Data.DataProvider.CardConfigs.UpdateCardConfig(cci);
}
/// <summary>
/// 添加名片配置
/// </summary>
/// <param name="cci"></param>
public static void InsertCardConfig(CardConfigInfo cci)
{
SAS.Data.DataProvider.CardConfigs.InsertCardConfig(cci);
}
