96 lines
3.2 KiB
C#
96 lines
3.2 KiB
C#
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
public class TDCService
|
|
{
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static DataTable GetDataTable(string EProjectId)
|
|
{
|
|
string strSql = "SELECT * FROM Editor_TDC where EProjectId=@EProjectId ORDER BY [Type],[Disc]";
|
|
SqlParameter[] parameter = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@EProjectId",EProjectId)
|
|
};
|
|
DataTable dt = SQLHelper.GetDataTableRunText(strSql, parameter);
|
|
return dt;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 批量增加
|
|
/// </summary>
|
|
/// <param name="model"></param>
|
|
public static void AddEditorTDC(List<Model.Editor_TDC> model)
|
|
{
|
|
Funs.DB.Editor_TDC.InsertAllOnSubmit(model);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据eproject删除所有TDC
|
|
/// </summary>
|
|
/// <param name=""></param>
|
|
public static void DeleteEditorTDC(string EProjectId)
|
|
{
|
|
var q = (from x in Funs.DB.Editor_TDC where x.EProjectId == EProjectId select x).ToList();
|
|
if (q != null)
|
|
{
|
|
Funs.DB.Editor_TDC.DeleteAllOnSubmit(q);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据ID删除
|
|
/// </summary>
|
|
/// <param name="tdcId"></param>
|
|
public static void DeleteEditorTDCById(string tdcId)
|
|
{
|
|
Model.Editor_TDC tdc = Funs.DB.Editor_TDC.FirstOrDefault(e => e.TDCId == tdcId);
|
|
if (tdc != null)
|
|
{
|
|
Funs.DB.Editor_TDC.DeleteOnSubmit(tdc);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
public static Model.Editor_TDC GetTDCByEprojectId(string eProjectId, string type)
|
|
{
|
|
var q = (from x in Funs.DB.Editor_TDC where x.EProjectId == eProjectId && x.Type == type select x).ToList();
|
|
if (q.Count > 1)
|
|
{
|
|
return (from x in Funs.DB.Editor_TDC where x.EProjectId == eProjectId && x.Type == type && x.Disc == "00_ALL" orderby x.ReceiveHC descending select x).FirstOrDefault();
|
|
}
|
|
else
|
|
{
|
|
return (from x in Funs.DB.Editor_TDC where x.EProjectId == eProjectId && x.Type == type orderby x.ReceiveHC descending select x).FirstOrDefault();
|
|
}
|
|
}
|
|
|
|
public static List<Model.View_TDCDiscValue> GetTDCDiscByEprojectId(string eprojectId)
|
|
{
|
|
var q= (from x in Funs.DB.View_TDCDiscValue orderby x.ConstValue where x.EProjectId == eprojectId || x.EProjectId =="" select x ).ToList();
|
|
return q;
|
|
}
|
|
|
|
public static bool IsExistTDC(string eprojectId, string type, string disc)
|
|
{
|
|
var q = from x in Funs.DB.Editor_TDC where x.EProjectId == eprojectId && x.Type == type && x.Disc == disc select x;
|
|
if (q.Count() > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
}
|