436 lines
17 KiB
C#
436 lines
17 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Text;
|
||
using System.Data;
|
||
|
||
using WeiSha.Common;
|
||
using Song.Entities;
|
||
|
||
using WeiSha.Data;
|
||
using Song.ServiceInterfaces;
|
||
using System.Data.Common;
|
||
|
||
|
||
|
||
namespace Song.ServiceImpls
|
||
{
|
||
public class GuideCom :IGuide
|
||
{
|
||
private string _artUppath = "Guide";
|
||
#region 考试指南
|
||
/// <summary>
|
||
/// 添加考试指南
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void GuideAdd(Guide entity)
|
||
{
|
||
//创建时间
|
||
entity.Gu_CrtTime = DateTime.Now;
|
||
if (entity.Gu_PushTime < DateTime.Now.AddYears(-100))
|
||
entity.Gu_PushTime = entity.Gu_CrtTime;
|
||
//所在机构
|
||
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
if (org != null)
|
||
{
|
||
entity.Org_ID = org.Org_ID;
|
||
entity.Org_Name = org.Org_Name;
|
||
}
|
||
//所属栏目
|
||
Song.Entities.GuideColumns nc = this.ColumnsSingle((int)entity.Gc_ID);
|
||
if (nc != null) entity.Gc_Title = nc.Gc_Title;
|
||
Gateway.Default.Save<Guide>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 修改
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void GuideSave(Guide entity)
|
||
{
|
||
//最后编辑时间
|
||
entity.Gu_LastTime = DateTime.Now;
|
||
if (entity.Gu_PushTime < DateTime.Now.AddYears(-100))
|
||
entity.Gu_PushTime = entity.Gu_CrtTime;
|
||
//所在机构
|
||
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
if (org != null)
|
||
{
|
||
entity.Org_ID = org.Org_ID;
|
||
entity.Org_Name = org.Org_Name;
|
||
}
|
||
//所属栏目
|
||
Song.Entities.GuideColumns nc = this.ColumnsSingle((int)entity.Gc_ID);
|
||
if (nc != null) entity.Gc_Title = nc.Gc_Title;
|
||
Gateway.Default.Save<Guide>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 删除
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void GuideDelete(Guide entity)
|
||
{
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
if (!string.IsNullOrWhiteSpace(entity.Gu_Uid))
|
||
{
|
||
//删除附件
|
||
Business.Do<IAccessory>().Delete(entity.Gu_Uid);
|
||
//删除图片文件
|
||
string img = WeiSha.Common.Upload.Get[_artUppath].Physics + entity.Gu_Logo;
|
||
if (System.IO.File.Exists(img))
|
||
System.IO.File.Delete(img);
|
||
}
|
||
tran.Delete<Guide>(Guide._.Gu_Id == entity.Gu_Id);
|
||
tran.Commit();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
tran.Rollback();
|
||
throw ex;
|
||
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void GuideDelete(int identify)
|
||
{
|
||
Song.Entities.Guide guide = this.GuideSingle(identify);
|
||
GuideDelete(guide);
|
||
}
|
||
/// <summary>
|
||
/// 当前新闻的上一条新闻
|
||
/// </summary>
|
||
/// <param name="entity"></param>
|
||
/// <returns></returns>
|
||
public Guide GuidePrev(Guide entity)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
wc &= Guide._.Gu_IsShow == true;
|
||
wc &= Guide._.Cou_ID == entity.Cou_ID;
|
||
wc &= Guide._.Gu_CrtTime > entity.Gu_CrtTime;
|
||
return Gateway.Default.From<Guide>().OrderBy(Guide._.Gu_CrtTime.Asc)
|
||
.Where(wc).ToFirst<Guide>();
|
||
}
|
||
/// <summary>
|
||
/// 当前新闻的下一条新闻
|
||
/// </summary>
|
||
/// <param name="entity"></param>
|
||
/// <returns></returns>
|
||
public Guide GuideNext(Guide entity)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
wc &= Guide._.Gu_IsShow == true;
|
||
wc &= Guide._.Cou_ID == entity.Cou_ID;
|
||
wc &= Guide._.Gu_CrtTime < entity.Gu_CrtTime;
|
||
return Gateway.Default.From<Guide>().OrderBy(Guide._.Gu_CrtTime.Desc)
|
||
.Where(wc).ToFirst<Guide>();
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public Guide GuideSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<Guide>().Where(Guide._.Gu_Id == identify).ToFirst<Guide>();
|
||
}
|
||
public Guide[] GuideCount(int orgid, int couid, int gcid, int count)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
wc &= Guide._.Gu_IsShow == true;
|
||
if (orgid > 0) wc &= Guide._.Org_ID == orgid;
|
||
if (couid > 0) wc &= Guide._.Cou_ID == couid;
|
||
if (gcid > 0) wc &= Guide._.Gc_ID == gcid;
|
||
return Gateway.Default.From<Guide>().Where(wc).ToArray<Guide>();
|
||
}
|
||
/// <summary>
|
||
/// 分页获取
|
||
/// </summary>
|
||
/// <param name="orgid"></param>
|
||
/// <param name="couid">课程id</param>
|
||
/// <param name="gcid">考试指南分类</param>
|
||
/// <param name="isShow">是否显示</param>
|
||
/// <param name="size"></param>
|
||
/// <param name="index"></param>
|
||
/// <param name="countSum"></param>
|
||
/// <returns></returns>
|
||
public Guide[] GetGuidePager(int orgid, int couid, int gcid, string searTxt, bool? isShow, int size, int index, out int countSum)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc.And(Guide._.Org_ID == orgid);
|
||
if (couid > 0) wc.And(Guide._.Cou_ID == couid);
|
||
if (gcid >=0) wc.And(Guide._.Gc_ID == gcid);
|
||
if (isShow != null) wc.And(Guide._.Gu_IsShow == (bool)isShow);
|
||
if (searTxt != null && searTxt.Trim() != "")
|
||
wc.And(Guide._.Gu_Title.Like("%" + searTxt + "%"));
|
||
countSum = Gateway.Default.Count<Guide>(wc);
|
||
return Gateway.Default.From<Guide>().Where(wc).OrderBy(Guide._.Gu_PushTime.Desc).ToArray<Guide>(size, (index - 1) * size);
|
||
}
|
||
/// <summary>
|
||
/// 分页获取
|
||
/// </summary>
|
||
/// <param name="orgid"></param>
|
||
/// <param name="couid"></param>
|
||
/// <param name="gcids">考试指南分类,多个id，逗号分隔</param>
|
||
/// <param name="searTxt"></param>
|
||
/// <param name="isShow"></param>
|
||
/// <param name="size"></param>
|
||
/// <param name="index"></param>
|
||
/// <param name="countSum"></param>
|
||
/// <returns></returns>
|
||
public Guide[] GetGuidePager(int orgid, int couid, string gcids, string searTxt, bool? isShow, int size, int index, out int countSum)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (orgid > 0) wc.And(Guide._.Org_ID == orgid);
|
||
if (couid > 0) wc.And(Guide._.Cou_ID == couid);
|
||
if (!string.IsNullOrWhiteSpace(gcids))
|
||
{
|
||
WhereClip wcSbjid = new WhereClip();
|
||
foreach (string tm in gcids.Split(','))
|
||
{
|
||
if (string.IsNullOrWhiteSpace(tm)) continue;
|
||
int sbj = 0;
|
||
int.TryParse(tm, out sbj);
|
||
if (sbj == 0) continue;
|
||
wcSbjid.Or(Guide._.Gc_ID == sbj);
|
||
}
|
||
wc.And(wcSbjid);
|
||
}
|
||
if (isShow != null) wc.And(Guide._.Gu_IsShow == (bool)isShow);
|
||
if (searTxt != null && searTxt.Trim() != "")
|
||
wc.And(Guide._.Gu_Title.Like("%" + searTxt + "%"));
|
||
countSum = Gateway.Default.Count<Guide>(wc);
|
||
return Gateway.Default.From<Guide>().Where(wc).OrderBy(Guide._.Gu_PushTime.Desc).ToArray<Guide>(size, (index - 1) * size);
|
||
}
|
||
#endregion
|
||
|
||
#region 考试指南分类
|
||
/// <summary>
|
||
/// 添加
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public int ColumnsAdd(GuideColumns entity)
|
||
{
|
||
entity.Gc_CrtTime = DateTime.Now;
|
||
//如果没有排序号，则自动计算
|
||
if (entity.Gc_Tax < 1)
|
||
{
|
||
object obj = Gateway.Default.Max<GuideColumns>(GuideColumns._.Gc_Tax, GuideColumns._.Cou_ID == entity.Cou_ID && GuideColumns._.Gc_PID == entity.Gc_PID);
|
||
entity.Gc_Tax = obj is int ? (int)obj + 1 : 0;
|
||
}
|
||
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
||
if (org != null)
|
||
{
|
||
entity.Org_ID = org.Org_ID;
|
||
entity.Org_Name = org.Org_Name;
|
||
}
|
||
return Gateway.Default.Save<GuideColumns>(entity);
|
||
}
|
||
/// <summary>
|
||
/// 修改
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ColumnsSave(GuideColumns entity)
|
||
{
|
||
Song.Entities.GuideColumns old = this.ColumnsSingle(entity.Gc_ID);
|
||
if (old.Gc_PID != entity.Gc_PID)
|
||
{
|
||
object obj = Gateway.Default.Max<GuideColumns>(GuideColumns._.Gc_Tax, GuideColumns._.Cou_ID == entity.Cou_ID && GuideColumns._.Gc_PID == entity.Gc_PID);
|
||
entity.Gc_Tax = obj is int ? (int)obj + 1 : 0;
|
||
}
|
||
using (DbTrans trans = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
trans.Save<GuideColumns>(entity);
|
||
trans.Update<GuideColumns>(new Field[] { Guide._.Gc_Title }, new object[] { entity.Gc_Title, }, GuideColumns._.Gc_ID == entity.Gc_ID);
|
||
trans.Commit();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
trans.Rollback();
|
||
throw ex;
|
||
}
|
||
finally
|
||
{
|
||
trans.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 删除
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
public void ColumnsDelete(GuideColumns entity)
|
||
{
|
||
Song.Entities.GuideColumns[] cols = GetColumnsChild(entity.Cou_ID, entity.Gc_ID, null);
|
||
foreach (Song.Entities.GuideColumns cl in cols)
|
||
ColumnsDelete(cl);
|
||
Gateway.Default.Delete<Guide>(Guide._.Gc_ID == entity.Gc_ID);
|
||
Gateway.Default.Delete<GuideColumns>(GuideColumns._.Gc_ID == entity.Gc_ID);
|
||
}
|
||
/// <summary>
|
||
/// 删除，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
public void ColumnsDelete(int identify)
|
||
{
|
||
Song.Entities.GuideColumns col = ColumnsSingle(identify);
|
||
ColumnsDelete(col);
|
||
}
|
||
/// <summary>
|
||
/// 获取单一实体对象，按主键ID；
|
||
/// </summary>
|
||
/// <param name="identify">实体的主键</param>
|
||
/// <returns></returns>
|
||
public GuideColumns ColumnsSingle(int identify)
|
||
{
|
||
return Gateway.Default.From<GuideColumns>().Where(GuideColumns._.Gc_ID == identify).ToFirst<GuideColumns>();
|
||
}
|
||
/// <summary>
|
||
/// 获取同一父级下的最大排序号；
|
||
/// </summary>
|
||
///<param name="couid">课程id</param>
|
||
///<param name="pid">学科id</param>
|
||
/// <returns></returns>
|
||
public int ColumnsMaxTaxis(int couid, int pid)
|
||
{
|
||
object obj = Gateway.Default.Max<GuideColumns>(GuideColumns._.Gc_Tax, GuideColumns._.Cou_ID == couid && GuideColumns._.Gc_PID == pid);
|
||
int tax = obj is int ? (int)obj + 1 : 0;
|
||
return tax;
|
||
}
|
||
/// <summary>
|
||
/// 获取对象；即所有分类；
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public GuideColumns[] GetColumnsAll(int couid, bool? isUse)
|
||
{
|
||
WhereClip wc = new WhereClip();
|
||
if (couid > 0) wc.And(GuideColumns._.Cou_ID == couid);
|
||
if (isUse != null) wc.And(GuideColumns._.Gc_IsUse == (bool)isUse);
|
||
return Gateway.Default.From<GuideColumns>().Where(wc).OrderBy(GuideColumns._.Gc_Tax.Asc).ToArray<GuideColumns>();
|
||
}
|
||
/// <summary>
|
||
/// 获取当前分类下的子分类
|
||
/// </summary>
|
||
/// <param name="pid"></param>
|
||
/// <param name="isUse"></param>
|
||
/// <returns></returns>
|
||
public GuideColumns[] GetColumnsChild(int couid, int pid, bool? isUse)
|
||
{
|
||
WhereClip wc = GuideColumns._.Cou_ID == couid;
|
||
if (pid >= 0) wc.And(GuideColumns._.Gc_PID == pid);
|
||
if (isUse != null) wc.And(GuideColumns._.Gc_IsUse == (bool)isUse);
|
||
return Gateway.Default.From<GuideColumns>().Where(wc).OrderBy(GuideColumns._.Gc_Tax.Asc).ToArray<GuideColumns>();
|
||
}
|
||
|
||
public bool ColumnsIsChildren(int couid, int pid, bool? isUse)
|
||
{
|
||
WhereClip wc = GuideColumns._.Cou_ID == couid;
|
||
if (pid >= 0) wc.And(GuideColumns._.Gc_PID == pid);
|
||
if (isUse != null) wc.And(GuideColumns._.Gc_IsUse == (bool)isUse);
|
||
int count = Gateway.Default.Count<GuideColumns>(wc);
|
||
return count > 0;
|
||
}
|
||
/// <summary>
|
||
/// 当前对象名称是否重名
|
||
/// </summary>
|
||
/// <param name="entity">业务实体</param>
|
||
/// <returns></returns>
|
||
public bool ColumnsIsExist(int couid, int pid, GuideColumns entity)
|
||
{
|
||
WhereClip wc = GuideColumns._.Gc_Title == entity.Gc_Title && GuideColumns._.Cou_ID == couid && GuideColumns._.Gc_PID == pid;
|
||
//如果是一个已经存在的对象
|
||
if (entity.Gc_ID == 0) wc = wc.And(GuideColumns._.Gc_ID == entity.Gc_ID);
|
||
GuideColumns mm = Gateway.Default.From<GuideColumns>().Where(wc).ToFirst<GuideColumns>();
|
||
return mm != null;
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向上移动；仅在当前对象的同层移动，即同一父节点下的对象这前移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ColumnsRemoveUp(int id)
|
||
{
|
||
//当前对象
|
||
GuideColumns current = Gateway.Default.From<GuideColumns>().Where(GuideColumns._.Gc_ID == id).ToFirst<GuideColumns>();
|
||
int tax = (int)current.Gc_Tax;
|
||
//上一个对象，即兄长对象；兄长不存则直接返回false;
|
||
GuideColumns prev = Gateway.Default.From<GuideColumns>()
|
||
.Where(GuideColumns._.Gc_Tax < tax && GuideColumns._.Gc_PID == current.Gc_PID && GuideColumns._.Cou_ID == current.Cou_ID)
|
||
.OrderBy(GuideColumns._.Gc_Tax.Desc).ToFirst<GuideColumns>();
|
||
if (prev == null) return false;
|
||
//交换排序号
|
||
current.Gc_Tax = prev.Gc_Tax;
|
||
prev.Gc_Tax = tax;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<GuideColumns>(current);
|
||
tran.Save<GuideColumns>(prev);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 将当前项目向下移动；仅在当前对象的同层移动，即同一父节点下的对象这前移动；
|
||
/// </summary>
|
||
/// <param name="id"></param>
|
||
/// <returns>如果已经处于顶端，则返回false；移动成功，返回true</returns>
|
||
public bool ColumnsRemoveDown(int id)
|
||
{
|
||
//当前对象
|
||
GuideColumns current = Gateway.Default.From<GuideColumns>().Where(GuideColumns._.Gc_ID == id).ToFirst<GuideColumns>();
|
||
int tax = (int)current.Gc_Tax;
|
||
//下一个对象，即弟弟对象；弟弟不存则直接返回false;
|
||
GuideColumns next = Gateway.Default.From<GuideColumns>()
|
||
.Where(GuideColumns._.Gc_Tax > tax && GuideColumns._.Gc_PID == current.Gc_PID && GuideColumns._.Cou_ID == current.Cou_ID)
|
||
.OrderBy(GuideColumns._.Gc_Tax.Asc).ToFirst<GuideColumns>();
|
||
if (next == null) return false;
|
||
//交换排序号
|
||
current.Gc_Tax = next.Gc_Tax;
|
||
next.Gc_Tax = tax;
|
||
using (DbTrans tran = Gateway.Default.BeginTrans())
|
||
{
|
||
try
|
||
{
|
||
tran.Save<GuideColumns>(current);
|
||
tran.Save<GuideColumns>(next);
|
||
tran.Commit();
|
||
return true;
|
||
}
|
||
catch
|
||
{
|
||
tran.Rollback();
|
||
throw;
|
||
}
|
||
finally
|
||
{
|
||
tran.Close();
|
||
}
|
||
}
|
||
}
|
||
|
||
#endregion
|
||
}
|
||
}
|