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()); } }
protected void ListBox_DataBound() { this.ddlclassID.Items.Clear(); this.ddlclassID.Items.Add(new ListItem("��ѡ��Ҫ�����ı�ǩ����", "-1")); XYECOM.Business.LabelType lt = new XYECOM.Business.LabelType(); String strwhere = " where LT_ParentID=0 "; DataTable dt = lt.GetDataTable(strwhere); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { this.ddlclassID.Items.Add(new ListItem(dt.Rows[i]["LT_Name"].ToString(), dt.Rows[i]["LT_ID"].ToString())); } } }