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