/// <summary> /// �Է������ת�� /// </summary> /// <param name="ename">ģ������</param> /// <param name="pt_parentID">����ID</param> /// <param name="flag">flag:0 ��ת�Ƶ����� flag:1 ����Ϊ����</param> private void Move(String ename, long lngMoveTypeId, String flag) { int err = 0; if (ename.Equals("job") || ename.Equals("exhibition")) { if (ename.Equals("job")) { postinfo = post.GetItem(Convert.ToInt32(lngMoveTypeId)); XYECOM.Model.PostInfo info = new XYECOM.Model.PostInfo(); info.P_ID = postinfo.P_ID; info.P_Name = postinfo.P_Name; if (toTypeId.Equals(lngMoveTypeId)) { info.P_ParentID = postinfo.P_ParentID; } else { info.P_ParentID = Convert.ToInt32(toTypeId); } if (flag.Equals("1")) { info.P_ParentID = 0; } err = post.Update(info); } if (ename.Equals("exhibition")) { showinfo = showtype.GetItem(lngMoveTypeId); XYECOM.Model.ShowTypeInfo info = new XYECOM.Model.ShowTypeInfo(); info.SHT_Name = showinfo.SHT_Name; if (toTypeId.Equals(lngMoveTypeId)) { info.SHT_ParentID = showinfo.SHT_ParentID; } else { info.SHT_ParentID = toTypeId; } if (flag.Equals("1")) { info.SHT_ParentID = 0; } info.SHT_ID = showinfo.SHT_ID; err = showtype.Update(info); } } else { if (ename.Equals("offer") || XYECOM.Configuration.Module.Instance.GetItem(ename).PEName.Equals("offer")) { proTypeInfo = proTypeBLL.GetItem(lngMoveTypeId); if (flag.Equals("1")) { proTypeInfo.PT_ParentID = 0; } else { if (toTypeId != lngMoveTypeId) { Model.ProductTypeInfo _tempInfo = proTypeBLL.GetItem(toTypeId); if (_tempInfo != null) proTypeInfo.TradeId = _tempInfo.TradeId; proTypeInfo.PT_ParentID = toTypeId; } } err = proTypeBLL.Update(proTypeInfo); } if (ename.Equals("investment") || XYECOM.Configuration.Module.Instance.GetItem(ename).PEName.Equals("investment")) { iti = it.GetItem(lngMoveTypeId); XYECOM.Model.InviteBusinessTypeInfo info = new XYECOM.Model.InviteBusinessTypeInfo(); info.IT_Name = iti.IT_Name; if (toTypeId.Equals(lngMoveTypeId)) { info.IT_ParentID = iti.IT_ParentID; } else { info.IT_ParentID = toTypeId; } if (flag.Equals("1")) { info.IT_ParentID = 0; } info.ModuleName = iti.ModuleName; info.IT_ID = iti.IT_ID; err = it.Update(info); } if (ename.Equals("service") || XYECOM.Configuration.Module.Instance.GetItem(ename).PEName.Equals("service")) { sti = st.GetItem(lngMoveTypeId); XYECOM.Model.ServiceTypeInfo info = new XYECOM.Model.ServiceTypeInfo(); info.ST_Name = sti.ST_Name; if (toTypeId.Equals(lngMoveTypeId)) { info.ST_ParentID = sti.ST_ParentID; } else { info.ST_ParentID = toTypeId; } if (flag.Equals("1")) { info.ST_ParentID = 0; } info.ModuleName = sti.ModuleName; info.ST_ID = sti.ST_ID; err = st.Update(info); } } if (err > 0) { Response.Redirect("Typelist.aspx?ename=" + ename + "&orderid=" + lngMoveTypeId); } else { this.lblMessage.Text = "ת��ʧ�ܣ�"; } }
/// <summary> /// ���ط��༯�� /// </summary> /// <returns></returns> public List<Model.ProductTypeInfo> GetItems() { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@strWhere",""), new SqlParameter("@strTableName","b_ProductType"), new SqlParameter("@strOrder","") }; List<Model.ProductTypeInfo> infos = new List<XYECOM.Model.ProductTypeInfo>(); using (SqlDataReader dr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_SelectByWhere", param)) { while (dr.Read()) { XYECOM.Model.ProductTypeInfo info = new XYECOM.Model.ProductTypeInfo(); info.PT_ID = Convert.ToInt64(dr["PT_ID"].ToString()); info.PT_Name = dr["PT_Name"].ToString(); info.PT_ParentID = Convert.ToInt64(dr["PT_ParentID"].ToString()); info.ModuleName = dr["ModuleName"].ToString(); info.FullId = dr["FullId"].ToString(); info.InfoCount = Core.MyConvert.GetInt32(dr["InfoCount"].ToString()); info.TradeId = Core.MyConvert.GetInt32(dr["TradeId"].ToString()); info.FlagName = dr["FlagName"].ToString(); info.IsCustomTemplate = dr["IsCustomTemplate"].ToString().Equals("True") ? true : false; infos.Add(info); } } return infos; }
/// <summary> /// ͨ������ID��ȡ�÷�����Ϣ ��������� 2011-03-30�� /// </summary> /// <param name="id">����Id</param> /// <returns>������Ϣ</returns> public Model.ProductTypeInfo GetProTypeById(int id) { string sql = "select * from b_producttype where pt_id = " + id + ""; XYECOM.Model.ProductTypeInfo info = null; using (SqlDataReader dr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, sql, null)) { if (dr.Read()) { info = new XYECOM.Model.ProductTypeInfo(); info.PT_ID = Convert.ToInt64(dr["PT_ID"].ToString()); info.PT_Name = dr["PT_Name"].ToString(); info.PT_ParentID = Convert.ToInt64(dr["PT_ParentID"].ToString()); info.ModuleName = dr["ModuleName"].ToString(); info.FullId = dr["FullId"].ToString(); info.InfoCount = Core.MyConvert.GetInt32(dr["InfoCount"].ToString()); info.TradeId = Core.MyConvert.GetInt32(dr["TradeId"].ToString()); info.FlagName = dr["FlagName"].ToString(); info.IsCustomTemplate = dr["IsCustomTemplate"].ToString().Equals("True") ? true : false; } } return info; }
/// <summary> /// /// </summary> /// <param name="keyword"></param> /// <returns></returns> public XYECOM.Model.ProductTypeInfo GetItemByTypeName(string keyword) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@strWhere","Where pt_name='" + keyword + "'"), new SqlParameter("@strTableName","b_ProductType"), new SqlParameter("@strOrder","") }; XYECOM.Model.ProductTypeInfo info = null; ; using (SqlDataReader dr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_SelectByWhere", param)) { if (dr.Read()) { info = new XYECOM.Model.ProductTypeInfo(); info.PT_ID = Convert.ToInt64(dr["PT_ID"].ToString()); info.PT_Name = dr["PT_Name"].ToString(); info.PT_ParentID = Convert.ToInt64(dr["PT_ParentID"].ToString()); info.ModuleName = dr["ModuleName"].ToString(); info.FullId = dr["FullId"].ToString(); info.InfoCount = Core.MyConvert.GetInt32(dr["InfoCount"].ToString()); info.TradeId = Core.MyConvert.GetInt32(dr["TradeId"].ToString()); info.FlagName = dr["FlagName"].ToString(); info.IsCustomTemplate = dr["IsCustomTemplate"].ToString().Equals("True") ? true : false; } } return info; }