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