/// <summary>
/// ��ȡָ�������Ϣ
/// </summary>
/// <param name="LT_ID">�����</param>
/// <returns>�����Ϣ</returns>
public XYECOM.Model.LabelTypeInfo GetItem(int LT_ID)
{
XYECOM.Model.LabelTypeInfo elt = null;
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@strWhere"," Where LT_ID=" + LT_ID.ToString()),
new SqlParameter("@strTableName","b_LabelType"),
new SqlParameter("@strOrder","")
};
using (SqlDataReader dr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure,"XYP_SelectByWhere", param))
{
if (dr.Read())
{
elt = new XYECOM.Model.LabelTypeInfo();
elt.LT_ID = LT_ID;
elt.LT_Name = dr["LT_Name"].ToString();
elt.LT_Remark = dr["LT_Remark"].ToString();
}
}
return elt;
}
private void LabelByType(int flag, String fieldpath)
{
int id = 0;
XmlDocument docxml = new XmlDocument();
DataTable dt = new DataTable();
docxml.Load(fieldpath);
XYECOM.Model.LabelTypeInfo ltinfo = new XYECOM.Model.LabelTypeInfo();
XmlNodeList nodetypelist = docxml.GetElementsByTagName("typeitem");
for (int i = 0; i < nodetypelist.Count; i++)
{
for (int j = 0; j < nodetypelist[i].ChildNodes.Count; j++)
{
fieldname = nodetypelist[i].ChildNodes[j].Name;
if (fieldname.Equals("LT_ID"))
{
ltinfo.LT_ID = Convert.ToInt32(nodetypelist[i].ChildNodes[j].FirstChild.Value);
}
if (fieldname.Equals("LT_Name"))
{
ltinfo.LT_Name = nodetypelist[i].ChildNodes[j].FirstChild.Value;
}
if (fieldname.Equals("LT_Remark"))
{
ltinfo.LT_Remark = nodetypelist[i].ChildNodes[j].FirstChild.Value;
}
}
id = GetTypeID(ltinfo.LT_Name, ltinfo);
}
XYECOM.Business.Label label = new XYECOM.Business.Label();
XYECOM.Model.LabelInfo info = new XYECOM.Model.LabelInfo();
XmlNodeList nodelist = docxml.GetElementsByTagName("item");
XmlElement ele = null;
string nodeVlaue = "";
for (int i = 0; i < nodelist.Count; i++)
{
for (int j = 1; j < nodelist[i].ChildNodes.Count; j++)
{
fieldname = nodelist[i].ChildNodes[j].Name;
ele = (XmlElement)nodelist[i];
nodeVlaue = XYECOM.Core.XML.XMLUtil.GetNodeValue(ele, fieldname);
if (fieldname.Equals("L_Name"))
{
dt = XYECOM.Core.Data.SqlHelper.ExecuteTable("select * from b_label where L_Name = '" + nodeVlaue + "'");
if (dt.Rows.Count > 0)
{
info.Id = Convert.ToInt32(dt.Rows[0]["L_ID"].ToString());
}
else
{
info.Id = 0;
}
info.LabelName = nodeVlaue;
}
if (fieldname.Equals("L_CName"))
{
info.LabelCName = nodeVlaue;
}
if (fieldname.Equals("LT_ID"))
{
info.LabelTypeId = id;
}
if (fieldname.Equals("L_TableName"))
{
info.LabelTableName = nodeVlaue;
}
if (fieldname.Equals("L_Content"))
{
info.LabelContent = nodeVlaue;
}
if (fieldname.Equals("L_StyleHead"))
{
info.LabelStyleHead = nodeVlaue;
}
if (fieldname.Equals("L_StyleContent"))
{
info.LabelStyleContent = nodeVlaue;
}
if (fieldname.Equals("L_StyleFooter"))
{
info.LabelStyleFooter = nodeVlaue;
}
}
if (info.Id.Equals(0))
{
label.Insert(info);
messagein += info.LabelCName + ",";
}
else
{
if (flag.Equals(0))
{
label.Update(info);
messageupdata += info.LabelCName + ",";
}
if (flag.Equals(1))
{
messagereturn += info.LabelCName + ",";
}
}
}
this.Label2.Text = "�����ǩ��" + messagein;
this.Label3.Text = "���±�ǩ��" + messageupdata;
this.Label4.Text = "������ǩ��" + messagereturn;
}
private int GetTypeID(String name,XYECOM.Model.LabelTypeInfo info)
{
DataTable dt = new DataTable();
XYECOM.Business.LabelType labeltype = new XYECOM.Business.LabelType();
XYECOM.Model.LabelTypeInfo typeinfo = new XYECOM.Model.LabelTypeInfo();
dt = XYECOM.Core.Data.SqlHelper.ExecuteTable("select * from b_labeltype where LT_Name = '"+ name +"'");
if (dt.Rows.Count > 0)
{
return Convert.ToInt32(dt.Rows[0]["LT_ID"].ToString());
}
else {
labeltype.Insert(info);
dt = XYECOM.Core.Data.SqlHelper.ExecuteTable("select * from b_labeltype where LT_Name = '" + info.LT_Name + "'");
return Convert.ToInt32(dt.Rows[0]["LT_ID"].ToString());
}
}
private XYECOM.Model.LabelTypeInfo GetFromXMLType(long id)
{
XmlDocument docXml = new XmlDocument();
DataTable dt = new DataTable();
docXml.Load(fieldpath);
XYECOM.Model.LabelTypeInfo ltinfo = new XYECOM.Model.LabelTypeInfo();
XmlNodeList nodetypelist = docXml.GetElementsByTagName("typeitem");
for (int i = 0; i < nodetypelist.Count; i++)
{
for (int j = 0; j < nodetypelist[i].ChildNodes.Count; j++)
{
fieldname = nodetypelist[i].ChildNodes[j].Name;
if (fieldname.Equals("LT_ID"))
{
ltinfo.LT_ID =Convert.ToInt32(nodetypelist[i].ChildNodes[j].FirstChild.Value);
}
if (fieldname.Equals("LT_Name"))
{
ltinfo.LT_Name = nodetypelist[i].ChildNodes[j].FirstChild.Value;
}
if (fieldname.Equals("LT_Remark"))
{
ltinfo.LT_Remark = nodetypelist[i].ChildNodes[j].FirstChild.Value;
}
}
if (ltinfo.LT_ID.ToString().Equals(id.ToString()))
{
return ltinfo;
}
}
return ltinfo;
}
