protected void BtnSave_Click(object sender, EventArgs e)
{
if (this.IsValid)
{
M_Label label = new M_Label();
label.LableName = this.TxtLabelName.Text;
label.LableType = 1;
label.LabelCate = this.TxtLabelType.Text;
label.Desc = this.TxtLabelIntro.Text;
label.Content = this.textContent.Text;
label.Param = "";
label.LabelTable = "";
label.LabelField = "";
label.LabelWhere = "";
label.LabelOrder = "";
label.LabelCount = "";
label.LabelID = DataConverter.CLng(this.HdnLabelID.Value);
if (label.LabelID == 0)
{
this.bll.AddLabel(label);
}
else
{
this.bll.UpdateLabel(label);
}
Response.Redirect("LabelManage.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string filename = base.Request.PhysicalApplicationPath + @"\" + "App_Data" + @"\" + "LabelExport.xml";
if (!FileSystemObject.IsExist(filename, FsoMethod.File))
function.WriteErrMsg("数据文件：../App_Data/LabelExport.xml 不存在");
try
{
DataSet ds = new DataSet();
M_Label info = new M_Label();
ds.ReadXml(filename);
DataTable dt = ds.Tables["Table"];
int count = dt.Rows.Count;
int i = 1;
foreach (DataRow dr in dt.Rows)
{
info.LabelID = 0;
info.LableName = dr["LabelName"].ToString();
info.LabelCate = dr["LabelCate"].ToString();
info.Desc = dr["LabelDesc"].ToString();
info.LableType = DataConverter.CLng(dr["LabelType"]);
info.Param = dr["LabelParam"].ToString();
info.LabelTable = dr["LabelTable"].ToString();
info.LabelField = dr["LabelField"].ToString();
info.LabelWhere = dr["LabelWhere"].ToString();
info.LabelOrder = dr["LabelOrder"].ToString();
info.LabelCount = dr["LabelCount"].ToString();
info.Content = dr["LabelContent"].ToString();
string str2 = ((i * 100) / count).ToString("F1");
str2 = str2 + "%";
if (this.bll.IsExist(info.LableName))
info.LableName = info.LableName + DataSecurity.RandomNum(4);
this.bll.AddLabel(info);
this.tp.Style["Width"] = str2;
this.tn.Text = str2;
this.tc.Text = i.ToString();
i++;
}
this.tp.Style["Width"] = "100%";
this.tn.Text = "100%";
this.tc.Text = count.ToString();
this.finallytd.Text = "导入完毕";
}
catch
{
function.WriteErrMsg("导入标签出现异常！");
}
}
public static M_Label GetInfoFromDataTable(XmlNode node, DataTable dt)
{
M_Label info = new M_Label();
if (dt == null || dt.Rows.Count < 1)
{
return(info);
}
DataRow dr = dt.Rows[0];
info.LabelID = info.ConvertToInt(node["LabelID"].InnerText);
info.LabelName = node["LabelName"].InnerText;
info.LabelType = info.ConvertToInt(node["LabelType"].InnerText);
info.LabelCate = node["LabelCate"].InnerText;
info.Desc = dr["LabelDesc"].ToString();
info.Param = dr["LabelParam"].ToString();
info.LabelTable = dr["LabelTable"].ToString();
info.LabelField = dr["LabelField"].ToString();
info.LabelWhere = dr["LabelWhere"].ToString();
info.LabelOrder = dr["LabelOrder"].ToString();
info.Content = dr["LabelContent"].ToString();
info.LabelCount = dr["LabelCount"].ToString();
info.LabelAddUser = info.ConvertToInt(GetFromDR(dt, "LabelAddUser", "0"));
info.LabelNodeID = info.ConvertToInt(GetFromDR(dt, "LabelNodeID", "0"));
info.Modeltypeinfo = GetFromDR(dt, "Modeltypeinfo");
info.addroot = GetFromDR(dt, "addroot");
info.setroot = GetFromDR(dt, "setroot");
info.Modelvalue = GetFromDR(dt, "Modelvalue");
info.Valueroot = GetFromDR(dt, "Valueroot");
info.IsOpen = info.ConvertToInt(GetFromDR(dt, "IsOpen"));
info.FalseContent = GetFromDR(dt, "FalseContent");
info.EmptyContent = GetFromDR(dt, "EmptyContent");
info.DataSourceType = GetFromDR(dt, "DataSourceType");
info.ConnectString = GetFromDR(dt, "ConnectString");
info.ProceName = GetFromDR(dt, "ProceName");
info.ProceParam = GetFromDR(dt, "ProceParam");
return(info);
}
private string ContentSourceLabelProc(string ilabel, int Cpage, int InfoID, string Result)
{
M_Label label = new M_Label();
B_Label bll = new B_Label();
Hashtable hb = GetParam(ilabel);
string temp = Result;
if (!hb.Contains("id"))
{
temp.Replace(ilabel, "[err:标签不正确]");
return temp;
}
label = bll.GetLabel(hb["id"].ToString());
string strSql = "Select ";
string sqlCount = "";
string sqlField = "";
string sqlTable = "";
string sqlWhere = "";
string sqlOrder = "";
if (string.IsNullOrEmpty(label.LabelField))
{
temp.Replace(ilabel, "[err:标签没有定义查询的字段数据]");
return temp;
}
else
{
sqlField = label.LabelField;
}
if (string.IsNullOrEmpty(label.LabelTable))
{
temp.Replace(ilabel, "[err:标签没有定义查询的数据表]");
return temp;
}
else
{
sqlTable = label.LabelTable;
}
if (!string.IsNullOrEmpty(label.LabelCount))
sqlCount = label.LabelCount;
if (!string.IsNullOrEmpty(label.LabelWhere))
sqlWhere = label.LabelWhere;
if (!string.IsNullOrEmpty(label.LabelOrder))
sqlOrder = label.LabelOrder;
//替换参数
if (!string.IsNullOrEmpty(label.Param))
{
string[] pa = label.Param.Split(new char[] { '|' });
string paname = "";
for (int i = 0; i < pa.Length; i++)
{
paname = pa[i].Split(new char[] { ',' })[0];
if (DataConverter.CLng(pa[i].Split(new char[] { ',' })[2]) == 2)
{
sqlWhere = sqlWhere.Replace("@" + paname, InfoID.ToString());
}
else
{
sqlField = sqlField.Replace("@" + paname, hb["" + paname + ""].ToString());
sqlWhere = sqlWhere.Replace("@" + paname, hb["" + paname + ""].ToString());
sqlCount = sqlCount.Replace("@" + paname, hb["" + paname + ""].ToString());
}
}
}
//组合查询语句
if (DataConverter.CLng(sqlCount) > 0)
strSql = strSql + "top " + sqlCount + " ";
strSql = strSql + sqlField + " ";
strSql = strSql + "From " + sqlTable + " ";
if (!string.IsNullOrEmpty(sqlWhere))
strSql = strSql + "Where " + sqlWhere + " ";
if (!string.IsNullOrEmpty(sqlOrder))
strSql = strSql + "Order by " + sqlOrder;
DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, strSql, null);
temp = temp.Replace(ilabel, "");
return GetHtmlSource(temp, hb["id"].ToString(), dt);
}
/// <summary>
/// 处理标签取得换算后的标签Html的代码
/// </summary>
/// <param name="ilabel"></param>
/// <returns></returns>
private string ContentLabelProc(string ilabel, int Cpage, int InfoID)
{
M_Label label = new M_Label();
B_Label bll = new B_Label();
Hashtable hb = GetParam(ilabel);
if (!hb.Contains("id"))
{
return "[err:标签不正确]";
}
label = bll.GetLabel(hb["id"].ToString());
if (label.LableType == 1)
{
return label.Content;
}
else
{
string labelcontent = label.Content;
string strSql = "Select ";
string sqlCount = "";
string sqlField = "";
string sqlTable = "";
string sqlWhere = "";
string sqlOrder = "";
string sqlIdentity = "";
sqlCount = label.LabelCount;
if (string.IsNullOrEmpty(label.LabelField))
{
return "[err:标签没有定义查询的字段数据]";
}
else
{
sqlField = label.LabelField;
}
if (string.IsNullOrEmpty(label.LabelTable))
{
return "[err:标签没有定义查询的数据表]";
}
else
{
sqlTable = label.LabelTable;
}
if (!string.IsNullOrEmpty(label.LabelWhere))
sqlWhere = label.LabelWhere;
if (!string.IsNullOrEmpty(label.LabelOrder))
sqlOrder = label.LabelOrder;
if (!string.IsNullOrEmpty(label.Param))
{
string[] pa = label.Param.Split(new char[] { '|' });
string paname = "";
for (int i = 0; i < pa.Length; i++)
{
paname = pa[i].Split(new char[] { ',' })[0];
if (DataConverter.CLng(pa[i].Split(new char[] { ',' })[2]) == 2)
{
sqlWhere = sqlWhere.Replace("@" + paname, InfoID.ToString());
}
else
{
labelcontent = labelcontent.Replace("@" + paname, hb["" + paname + ""].ToString());
sqlField = sqlField.Replace("@" + paname, hb["" + paname + ""].ToString());
sqlWhere = sqlWhere.Replace("@" + paname, hb["" + paname + ""].ToString());
sqlCount = sqlCount.Replace("@" + paname, hb["" + paname + ""].ToString());
}
}
}
if (label.LableType == 2)
{
if (DataConverter.CLng(sqlCount) > 0)
strSql = strSql + "top " + sqlCount + " ";
strSql = strSql + sqlField + " ";
strSql = strSql + "From " + sqlTable + " ";
if (!string.IsNullOrEmpty(sqlWhere))
strSql = strSql + "Where " + sqlWhere + " ";
if (!string.IsNullOrEmpty(sqlOrder))
strSql = strSql + "Order by " + sqlOrder;
DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, strSql, null);
return GetHtmlContent(labelcontent, dt);
}
else
{
strSql = "PR_GetRecordFromPage";
SqlParameter[] cmdParam = new SqlParameter[] {
new SqlParameter("@TableName",SqlDbType.VarChar), //表名，可以是多个表
new SqlParameter("@Identity",SqlDbType.VarChar),
new SqlParameter("@Fields",SqlDbType.VarChar), //要取出的字段，可以是多个表的字段，可以为空，为空表示select *
new SqlParameter("@sqlWhere",SqlDbType.VarChar), //条件，可以为空，不用填 where
new SqlParameter("@OrderField",SqlDbType.VarChar), //排序字段，可以为空，为空默认按主键升序排列，不用填 order by
new SqlParameter("@pageSize",SqlDbType.Int), //每页记录数
new SqlParameter("@pageIndex",SqlDbType.Int) //当前页，1表示第1页
};
cmdParam[0].Value = sqlTable;
cmdParam[1].Value = sqlIdentity;
cmdParam[2].Value = sqlField;
cmdParam[3].Value = sqlWhere;
cmdParam[4].Value = sqlOrder;
cmdParam[5].Value = DataConverter.CLng(sqlCount);
cmdParam[6].Value = Cpage - 1;
DataSet ds = SqlHelper.ExecuteDataSet(CommandType.StoredProcedure, strSql, cmdParam);
DataTable dt = ds.Tables[0];
DataTable dt1 = ds.Tables[1];
int Count = DataConverter.CLng(dt.Rows[0][0]);
labelcontent = labelcontent.Replace("{ZL.Page/}", function.ShowlistPage(Count, DataConverter.CLng(sqlCount), Cpage, true, InfoID));
return GetHtmlContent(labelcontent, dt1);
}
}
}
public void AddLabel(M_Label label)
{
dal.AddLabel(label);
}
public void UpdateLabel(M_Label label)
{
dal.UpdateLabel(label);
}
/// <summary>
/// 保存标签
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSave_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
M_Label LabelInfo = new M_Label();
LabelInfo.LabelID = DataConverter.CLng(this.HdnlabelID.Value);
LabelInfo.LableName = this.TxtLabelName.Text;
LabelInfo.LableType = DataConverter.CLng(this.RBLType.SelectedValue);
LabelInfo.LabelCate = this.TxtLabelType.Text;
LabelInfo.Desc = this.TxtLabelIntro.Text;
LabelInfo.Param = this.HdnParam.Value;
LabelInfo.LabelTable = this.TxtSqlTable.Text;
LabelInfo.LabelField = this.TxtSqlField.Text;
LabelInfo.LabelWhere = this.TxtSqlWhere.Text;
LabelInfo.LabelOrder = this.TxtOrder.Text;
LabelInfo.Content = this.textContent.Text;
if (string.IsNullOrEmpty(this.TextBox1.Text))
{
LabelInfo.LabelCount = "0";
}
else
{
LabelInfo.LabelCount = this.TextBox1.Text;
}
if (LabelInfo.LabelID > 0)
this.bll.UpdateLabel(LabelInfo);
else
this.bll.AddLabel(LabelInfo);
Response.Redirect("LabelManage.aspx");
}
}
void ID_Label.AddLabel(M_Label label)
{
string strSql = "PR_Label_Add";
SqlParameter[] cmdParams = GetParameters(label);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
private static SqlParameter[] GetParameters(M_Label Info)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@LabelID", SqlDbType.Int),
new SqlParameter("@LabelName",SqlDbType.NVarChar,50),
new SqlParameter("@LabelType",SqlDbType.Int),
new SqlParameter("@LabelCate",SqlDbType.NVarChar,50),
new SqlParameter("@LabelDesc",SqlDbType.NVarChar,255),
new SqlParameter("@LabelParam",SqlDbType.NText),
new SqlParameter("@LabelTable",SqlDbType.NText),
new SqlParameter("@LabelField",SqlDbType.NText),
new SqlParameter("@LabelWhere",SqlDbType.NText),
new SqlParameter("@LabelOrder",SqlDbType.NText),
new SqlParameter("@LabelContent",SqlDbType.NText),
new SqlParameter("@LabelCount",SqlDbType.NVarChar,50)
};
parameter[0].Value = Info.LabelID;
parameter[1].Value = Info.LableName;
parameter[2].Value = Info.LableType;
parameter[3].Value = Info.LabelCate;
parameter[4].Value = Info.Desc;
parameter[5].Value = Info.Param;
parameter[6].Value = Info.LabelTable;
parameter[7].Value = Info.LabelField;
parameter[8].Value = Info.LabelWhere;
parameter[9].Value = Info.LabelOrder;
parameter[10].Value = Info.Content;
parameter[11].Value = Info.LabelCount;
return parameter;
}
private static M_Label GetInfoFromReader(SqlDataReader rdr)
{
M_Label label = new M_Label();
label.LabelID = DataConverter.CLng(rdr["LabelID"]);
label.LableName = rdr["LabelName"].ToString();
label.LableType = DataConverter.CLng(rdr["LabelType"]);
label.LabelCate = rdr["LabelCate"].ToString();
label.Desc = rdr["LabelDesc"].ToString();
label.Param = rdr["LabelParam"].ToString();
label.LabelTable = rdr["LabelTable"].ToString();
label.LabelField = rdr["LabelField"].ToString();
label.LabelWhere = rdr["LabelWhere"].ToString();
label.LabelOrder = rdr["LabelOrder"].ToString();
label.Content = rdr["LabelContent"].ToString();
label.LabelCount = rdr["LabelCount"].ToString();
return label;
}
