/// <summary> /// ��ȡ�����ǩ���� /// </summary> /// <param name="Id">�����ǩId</param> /// <returns>���ݶ���</returns> public Model.ClassLabelInfo GetItem(int Id) { XYECOM.Model.ClassLabelInfo info = null; Object obj= GetCache(); if (obj != null) { DataTable table = (DataTable)obj; DataRow[] rows = table.Select("Id =" + Id); if (rows.Length >0) { info = new XYECOM.Model.ClassLabelInfo(); info.ID = Id; info.Name = rows[0]["name"].ToString(); info.Body = rows[0]["body"].ToString(); info.TableName = rows[0]["tableName"].ToString(); info.CNName = rows[0]["CNName"].ToString(); } } return info; }
protected void btnOK_Click(object sender, EventArgs e) { string labelName = "XY_TSN_" + txtName.Text.Trim(); string CNName = txtCNName.Text.Trim(); if (labelName.Equals("") || CNName.Equals("")) { Alert("��ǩ���Ƽ��������Ʋ���Ϊ�գ�"); return; } Model.ClassLabelInfo info = new XYECOM.Model.ClassLabelInfo(); System.Text.StringBuilder body = new System.Text.StringBuilder(""); body.Append("<ul>").Append(((char)10).ToString()); for (int i = 0; i < chklstTrade.Items.Count; i++) { if (chklstTrade.Items[i].Selected) { body.Append("<li><a href='[TSN:" + chklstTrade.Items[i].Value + "]' target='_blank'>" + chklstTrade.Items[i].Text + "</a></li>"); body.Append(((char)10).ToString()); } } body.Append("</ul>"); info.Body = body.ToString(); info.Name = labelName; info.CNName = CNName; info.TableName = ""; new Business.ClassLabel().Insert(info); Response.Redirect("ClassLabelList.aspx"); }
/// <summary> /// ���з����ǩ /// </summary> /// <param name="falg">flag:0 ����/flag:1 ����</param> private void AllTypeLable(int falg,String fieldpath) { XmlDocument docXml = new XmlDocument(); DataTable dt = new DataTable(); int result = 0; docXml.Load(fieldpath); XYECOM.Business.ClassLabel cl = new XYECOM.Business.ClassLabel(); XYECOM.Model.ClassLabelInfo info = new XYECOM.Model.ClassLabelInfo(); XmlNodeList nodelist = docXml.GetElementsByTagName("item"); for (int i = 0; i < nodelist.Count; i++) { for (int j = 1; j < nodelist[i].ChildNodes.Count; j++) { fieldname = nodelist[i].ChildNodes[j].Name; if (fieldname.Equals("Name")) { dt = XYECOM.Core.Data.SqlHelper.ExecuteTable("select * from xy_classlabel where Name = '" + nodelist[i].ChildNodes[j].FirstChild.Value + "'"); if (dt.Rows.Count > 0) { info.ID = Convert.ToInt32(dt.Rows[0]["id"].ToString()); info.Name = nodelist[i].ChildNodes[j].FirstChild.Value; } else { info.ID = 0; info.Name = nodelist[i].ChildNodes[j].FirstChild.Value; } } if (fieldname.Equals("CNName")) { info.CNName = nodelist[i].ChildNodes[j].FirstChild.Value; } if (fieldname.Equals("Body")) { info.Body = nodelist[i].ChildNodes[j].FirstChild.Value; } if (fieldname.Equals("TableName")) { info.TableName = nodelist[i].ChildNodes[j].FirstChild.Value; } } if (info.ID.Equals(0)) { result = cl.Insert(info); messagein += info.CNName + ","; } else { if(falg.Equals(0)){ result = cl.Update(info); messageupdata += info.CNName + ","; } if (falg.Equals(1)) { messagereturn += info.CNName + ","; } } } this.Label2.Text = "�����ǩ��" + messagein; this.Label3.Text = "���±�ǩ��" + messageupdata; this.Label4.Text = "������ǩ��" + messagereturn; }
/// <summary> /// ��ȡ�����ǩ���� /// </summary> /// <param name="name">��ǩ����</param> /// <returns>���ݶ���</returns> public Model.ClassLabelInfo GetItem(string name) { XYECOM.Model.ClassLabelInfo info = null; Object obj = GetCache(); if (obj != null) { DataTable table = (DataTable)obj; DataRow[] rows = table.Select("Name ='" + name + "'"); if (rows.Length > 0) { info = new XYECOM.Model.ClassLabelInfo(); info.ID = Core.MyConvert.GetInt32(rows[0]["Id"].ToString()); info.Name = name; info.Body = rows[0]["body"].ToString(); info.TableName = rows[0]["tableName"].ToString(); info.CNName = rows[0]["CNName"].ToString(); } } return info; }