protected void rptSkin_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName.Equals("skin"))
{
txtSkinID.Value = e.CommandArgument + "";
((LinkButton)e.Item.FindControl("btnSkin")).CssClass = "";
BindPage(e.CommandArgument + "");
}
else if (e.CommandName.Equals("del"))
{
string SkinID = e.CommandArgument + "";
string StrSql = "select * from YiHui_HomePage_Skin where SkinID='" + SkinID + "';";
StrSql += "select * from YiHui_HomePage where SkinID='" + SkinID + "';";
StrSql += "select * from YiHui_HomePage_Model where SkinID='" + SkinID + "'";
DataSet dsData = DataBaseHelper.GetDataSet(StrSql);
dsData.Tables[0].PrimaryKey = new DataColumn[] { dsData.Tables[0].Columns["SkinID"] };
dsData.Tables[1].PrimaryKey = new DataColumn[] { dsData.Tables[1].Columns["PageID"] };
dsData.Tables[2].PrimaryKey = new DataColumn[] { dsData.Tables[2].Columns["PMID"] };
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
dsData.Tables[0].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[1].Rows.Count; i++)
{
dsData.Tables[1].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[2].Rows.Count; i++)
{
dsData.Tables[2].Rows[i].Delete();
}
DataBaseHelper.CommitDataSet(dsData, StrSql.Split(';'));
BindData();
}
}
/// <summary>
/// 数据同步数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void excelDS(object sender, EventArgs e)
{
try
{
if (ViewState["dtOrder"] != null)
{
dtOrder = (DataSet)ViewState["dtOrder"];
}
DeleteSameRow(dtOrder.Tables[0], "Sender");
string sqls = "select*from Hishop_Orders;select*from Hishop_OrderItems;select*from Hishop_SKUs";
string[] sql = sqls.Split(';');
int count = DataBaseHelper.CommitDataSet(dtOrder, sql);
if (count > 0)
{
this.ShowMsg("导入成功！", true);
}
else
{
this.ShowMsg("数据同步失败！", false);
}
}
catch (Exception ex)
{
this.ShowMsg("出错了：" + ex.Message, false);
}
finally
{
ViewState["dtOrder"] = null;
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
ManagerInfo currentManager = ManagerHelper.GetCurrentManager();
int PageType = 0;
int delType = 11;
if (currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "1")
{
return;
}
if (currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "2")
{
return;
}
if (!currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "2")
{
PageType = 21;
delType = 31;
}
if (!currentManager.UserName.Equals("yihui"))
{
string selectSql = string.Format("Select * From YiHui_HomePage Where PageType={0};", PageType);
selectSql += string.Format("Select * From YiHui_HomePage_Model Where PageID in(Select PageID From YiHui_HomePage Where PageType={0});", PageType);
selectSql += string.Format("Select * From YiHui_HomePage Where PageType={0};", delType);
selectSql += string.Format("Select * From YiHui_HomePage_Model Where PageID in(Select PageID From YiHui_HomePage Where PageType={0});", delType);
selectSql += string.Format("Select * From YiHui_HomePage Where 1=2;");
selectSql += string.Format("Select * From YiHui_HomePage_Model Where 1=2");
DataSet dsData = DataBaseHelper.GetDataSet(selectSql);
for (int i = 0; i < dsData.Tables[2].Rows.Count; i++)
{
dsData.Tables[2].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[3].Rows.Count; i++)
{
dsData.Tables[3].Rows[i].Delete();
}
//dsData table1和2 代表初始模板 table2和3 代表还原时需要删除的数据 4和5 代表需要新增的数据
foreach (DataRow dr in dsData.Tables[0].Rows)
{
DataRow OldHpmdr = dsData.Tables[1].Select(" PageID='" + dr["PageID"].ToString() + "'")[0];
DataRow hpdr = dsData.Tables[4].NewRow();
DataRow hpmdr = dsData.Tables[5].NewRow();
hpdr.ItemArray = dr.ItemArray;
hpmdr.ItemArray = OldHpmdr.ItemArray;
Guid pageid = Guid.NewGuid();
hpdr["PageID"] = pageid;
hpmdr["PageID"] = pageid;
hpmdr["PMID"] = Guid.NewGuid();
hpdr["PageType"] = delType;
dsData.Tables[4].Rows.Add(hpdr);
dsData.Tables[5].Rows.Add(hpmdr);
}
DataBaseHelper.CommitDataSet(dsData, selectSql.Split(';'));
BindData();
}
}
public void Save()
{
ManagerInfo currentManager = ManagerHelper.GetCurrentManager();
int PageType = 11;
if (currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "1")
{
PageType = 0;
}
if (currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "2")
{
PageType = 21;
}
if (!currentManager.UserName.Equals("yihui") && Request.QueryString["t"] == "2")
{
PageType = 31;
}
string selectSql = string.Format("Select * From YiHui_HomePage Where PageType={0};", PageType);
selectSql += string.Format("Select * From YiHui_HomePage_Model Where PageID in(Select PageID From YiHui_HomePage Where PageType={0});", PageType);
selectSql += string.Format("Select * From YiHui_HomePage Where 1=2;");
selectSql += string.Format("Select * From YiHui_HomePage_Model Where 1=2");
DataSet dsData = DataBaseHelper.GetDataSet(selectSql);
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
dsData.Tables[0].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[1].Rows.Count; i++)
{
dsData.Tables[1].Rows[i].Delete();
}
string str = txtRes.Value;
if (str != "")
{
str = str.TrimEnd('○');
string[] strModels = str.Split('○');
int m = 1;
foreach (string modelstr in strModels)
{
string[] AttrStrs = modelstr.Split('●');
DataRow hpdr = dsData.Tables[2].NewRow();
DataRow hpmdr = dsData.Tables[3].NewRow();
hpdr["PageType"] = PageType;
hpdr["PageSN"] = m;
Guid pageid = Guid.NewGuid();
hpdr["PageID"] = pageid;
hpdr["ModelCode"] = AttrStrs[0];
hpmdr["PageID"] = pageid;
hpmdr["ModelCode"] = AttrStrs[0];
hpmdr["PMID"] = Guid.NewGuid();
switch (AttrStrs[0])
{
case "DianZhao":
break;
case "DaoHang":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1; //是否显示图片
hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1;; //是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "WenBen":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "GunDong":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "TuPian":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1; //是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "HuanDeng":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1;//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "SouSuo":
break;
case "ShangPin":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "LieBiao":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
hpmdr["PMTop"] = AttrStrs[5]; //显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
hpmdr["PMValue1"] = AttrStrs[7]; //背景颜色和文字颜色
break;
case "KongBai":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
// hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
//hpmdr["PMContents"] = AttrStrs[6];//内容
break;
case "BeiJing":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
// hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "VDaoHang":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
hpmdr["PMImgDisplay"] = AttrStrs[2] == "none" ? 2 : 1; //是否显示图片
hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1;; //是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
hpmdr["PMValue1"] = AttrStrs[7]; //宽度
hpmdr["PMValue2"] = AttrStrs[8]; //位置 top 和left
break;
case "VWenBen":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
//hpmdr["PMValue1"] = AttrStrs[7];//宽度
hpmdr["PMValue2"] = AttrStrs[8]; //位置 top 和left
break;
case "VGunDong":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
//hpmdr["PMValue1"] = AttrStrs[7];//宽度
hpmdr["PMValue2"] = AttrStrs[8]; //位置 top 和left
break;
case "VTuPian":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1; //是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
//hpmdr["PMValue1"] = AttrStrs[7];//宽度
hpmdr["PMValue2"] = AttrStrs[8]; //位置 top 和left
break;
case "VHuanDeng":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1;//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
//hpmdr["PMValue1"] = AttrStrs[7];//宽度
hpmdr["PMValue2"] = AttrStrs[8]; //位置 top 和left
break;
}
dsData.Tables[2].Rows.Add(hpdr);
dsData.Tables[3].Rows.Add(hpmdr);
m++;
}
}
DataBaseHelper.CommitDataSet(dsData, selectSql.Split(';'));
BindData();
}
public void Save()
{
//开始保存
//得到投票活动Id参数值
string strVoteId = Request.QueryString["VoteId"].ToString();
string selectSql = string.Format("Select * From Yihui_Votes_Model Where VoteId={0};", strVoteId);
selectSql += string.Format("Select * From YiHui_HomePage_Model Where PageID in(Select VMID From Yihui_Votes_Model Where VoteId={0});", strVoteId);
selectSql += string.Format("Select * From YiHui_Votes_Model_Detail Where VMID in(Select VMID From Yihui_Votes_Model Where VoteId={0});", strVoteId);
selectSql += string.Format("Select * From Yihui_Votes_Model Where 1=2;");
selectSql += string.Format("Select * From YiHui_HomePage_Model Where 1=2;");
selectSql += string.Format("Select * From YiHui_Votes_Model_Detail Where 1=2;");
selectSql += string.Format("Select * From YiHui_Votes_Model_Result Where VoteId={0}", strVoteId);
DataSet dsData = DataBaseHelper.GetDataSet(selectSql);
//清空投票模块表，及模块内容表
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
dsData.Tables[0].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[1].Rows.Count; i++)
{
dsData.Tables[1].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[2].Rows.Count; i++)
{
dsData.Tables[2].Rows[i].Delete();
}
for (int i = 0; i < dsData.Tables[6].Rows.Count; i++)
{
dsData.Tables[6].Rows[i].Delete();
}
string str = txtRes.Value;
if (str != "")
{
str = str.TrimEnd('○');
string[] strModels = str.Split('○');
int m = 1;
foreach (string modelstr in strModels)
{
string[] AttrStrs = modelstr.Split('●');
DataRow vmdr = dsData.Tables[3].NewRow();
DataRow hpmdr = dsData.Tables[4].NewRow();
//构建Votes_Model表
Guid vmid = Guid.NewGuid();
vmdr["VMID"] = vmid;
vmdr["VoteId"] = strVoteId;
vmdr["ModelCode"] = AttrStrs[0];
vmdr["ModelSN"] = m;
//构建Page_Model表
hpmdr["PMID"] = Guid.NewGuid();
hpmdr["PageID"] = vmid;
hpmdr["ModelCode"] = AttrStrs[0];
hpmdr["PMID"] = Guid.NewGuid();
switch (AttrStrs[0])
{
case "WenBen":
hpmdr["PMHeight"] = AttrStrs[1]; //高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
//hpmdr["PMTxtDisplay"] = AttrStrs[3];//是否显示文字
//hpmdr["PMStyle"] = AttrStrs[4];//样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "TuPian":
//hpmdr["PMHeight"] = AttrStrs[1];//高度
//hpmdr["PMImgDisplay"]=AttrStrs[2]=="none"?2:1;//是否显示图片
hpmdr["PMTxtDisplay"] = AttrStrs[3] == "none" ? 2 : 1; //是否显示文字
hpmdr["PMStyle"] = AttrStrs[4]; //样式
//hpmdr["PMTop"] = AttrStrs[5];//显示个数
hpmdr["PMContents"] = AttrStrs[6]; //内容
break;
case "ShuRuKuang":
//hpmdr["PMHeight"] = AttrStrs[1];
//hpmdr["PMImgDisplay"] = AttrStrs[2];
//hpmdr["PMTxtDisplay"] = AttrStrs[3];
hpmdr["PMStyle"] = AttrStrs[4];
hpmdr["PMTop"] = AttrStrs[5];
hpmdr["PMContents"] = AttrStrs[6];
break;
case "ShiJian":
//hpmdr["PMHeight"] = AttrStrs[1];
//hpmdr["PMImgDisplay"] = AttrStrs[2];
//hpmdr["PMTxtDisplay"] = AttrStrs[3];
//hpmdr["PMStyle"] = AttrStrs[4];
hpmdr["PMTop"] = AttrStrs[5];
hpmdr["PMContents"] = AttrStrs[6];
break;
case "XuanXiang":
//hpmdr["PMHeight"] = AttrStrs[1];
//hpmdr["PMImgDisplay"] = AttrStrs[2];
//hpmdr["PMTxtDisplay"] = AttrStrs[3];
hpmdr["PMStyle"] = AttrStrs[4];
hpmdr["PMTop"] = AttrStrs[5];
hpmdr["PMContents"] = AttrStrs[6];
//保存选项明细
string[] strDetail = AttrStrs[6].Split('♦');
if (strDetail.Length == 3)
{
string[] strItems = strDetail[2].Split('♢');
foreach (string strItem in strItems)
{
string[] strValues = strItem.Split('□');
if (strValues.Length == 3)
{
DataRow vmddr = dsData.Tables[5].NewRow();
vmddr["MDID"] = Guid.NewGuid();
vmddr["VMID"] = vmid;
vmddr["Value"] = strValues[1];
vmddr["Name"] = strValues[1];
vmddr["Scode"] = Convert.ToInt32(strValues[0]);
dsData.Tables[5].Rows.Add(vmddr);
}
}
}
break;
}
dsData.Tables[3].Rows.Add(vmdr);
dsData.Tables[4].Rows.Add(hpmdr);
m++;
}
}
DataBaseHelper.CommitDataSet(dsData, selectSql.Split(';'));
BindData();
}
