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; }