public byte[] GetChnnalPhoto(int ChnId, bool IsLeaf)
{
return((byte[])SqlMapDAL.CreateNameQuery("GetChnnalPhoto")
.SetParameter("ChnOrLeafId", ChnId)
.SetParameter("IsChn", IsLeaf?0: 1)
.ExecuteScalar());
}
/// <summary>
/// 提交资源请求
/// </summary>
/// <param name="Title"></param>
/// <param name="Description"></param>
/// <param name="EndDate"></param>
/// <param name="UserID"></param>
/// <param name="UserName"></param>
/// <returns></returns>
public string ResourceRequest(string Title, string Description, DateTime EndDate, int UserID, string UserName, int UserType, int NextUserID, string NextUser)
{
string data = "{\"result\":\"success\",\"message\":\"请求已成功提交\"}";
try
{
var pk = SqlMapDAL.CreateNameQuery("SaveResourceRequest")
.SetParameter("Title", Title)
.SetParameter("Description", Description)
.SetParameter("EndDate", EndDate)
.SetParameter("UserID", UserID)
.SetParameter("UserName", UserName)
.SetParameter("UserType", UserType)
.ExecuteScalar();
int RequestID = int.Parse(pk.ToString());
ResourceRequestWF workflow = new ResourceRequestWF();
// 初始化流程
string ProcessID = workflow.Create(RequestID, Title, "资源申请业务流程");
workflow.Approve(RequestID, 0, UserID, UserName, NextUserID, NextUser, "提交资源请求", 1);
}
catch (Exception ex)
{
var obj = new { result = "fail", message = ex.Message };
data = JsonConvert.SerializeObject(obj);
}
return(data);
}
public void DelReportFile(long docId, int fileId)
{
SqlMapDAL.CreateNameQuery("DelReportFile")
.SetParameter("FileId", fileId)
.SetParameter("DocId", docId)
.ExecuteNonQuery();
}
public List <ReportHitInfo> GetReportetDocByHit(int period, int topNumber)
{
//string key = period + "_" + topNumber;
//object obj = CacheUtility.GetInstance().Get(key,CacheType.文件);
//if (obj != null) return obj as List<ReportHitInfo> ;
List <ReportHitInfo> tt = new List <ReportHitInfo>();
tt = SqlMapDAL.CreateNameQuery("GetReportetDocByHit")
.SetParameter("period", period)
.SetParameter("topNumber", topNumber).ListEntity <ReportHitInfo>();
List <ReportHitInfo> result = new List <ReportHitInfo>();
result.AddRange(tt);
if (tt.Count < topNumber)
{
int addnum = topNumber - tt.Count;
List <ReportHitInfo> ttadd = new List <ReportHitInfo>();
ttadd = SqlMapDAL.CreateNameQuery("GetReportetDocByHitAdd")
.SetParameter("topNumber", addnum).ListEntity <ReportHitInfo>();
result.AddRange(ttadd);
}
// CacheUtility.GetInstance().Add(key,result,new TimeSpan(0,1,0),CacheType.文件);
return(result);
}
public void DelReportTag(long docId, string tagName)
{
SqlMapDAL.CreateNameQuery("DelReportTag")
.SetParameter("DocId", docId)
.SetParameter("TagName", tagName)
.ExecuteNonQuery();
}
public void DelReport(int leafId, string docIds)
{
SqlMapDAL.CreateNameQuery("DelReport")
.ReplaceText("{0}", docIds)
.SetParameter("LeafId", leafId)
.ExecuteNonQuery();
}
public ChannelInfo GetLeafInfo(int chnId, int leafid)
{
return
(SqlMapDAL.CreateNameQuery("GetChannelLeafInfo")
.SetParameter("chnid", chnId).SetParameter("leafid", leafid)
.Entity <ChannelInfo>());
}
public List <ReportBasicInfo> GetCensorReportListByLeafIdWithOutTagName(int leafId, int curPage, int pagesize, Dictionary <string, string> condition, string orderbyField, bool isAsc, out int total)
{
string sqlCondition = "";
if (condition.Count > 0)
{
sqlCondition = condition.Aggregate(sqlCondition, (current, kvp) => current + (" and [" + kvp.Key + "] like '%" + kvp.Value + "%' "));
}
string orderby = "order by DelivedDate desc";
if (!string.IsNullOrEmpty(orderbyField))
{
if (orderbyField.ToLower() == "createdate")
{
orderbyField = "a.createdate ";
}
orderby = " order by " + orderbyField + " " + (isAsc ? "asc" : "desc");
}
total = 0;
List <ReportBasicInfo> list = SqlMapDAL.CreateNameQuery("GetCensorReportListByLeafIdWithOutTagName")
.AppendText(sqlCondition)
.AppendText(orderby)
.SetParameter("LeafId", leafId).ListEntityByPage <ReportBasicInfo>(curPage, pagesize, out total);
return(list);
}
/// <summary>
/// 资源请求处理列表分页数据
/// </summary>
/// <param name="limit"></param>
/// <param name="offset"></param>
/// <param name="sort"></param>
/// <param name="sortOrder"></param>
/// <param name="UserID"></param>
/// <param name="Title"></param>
/// <param name="Begin"></param>
/// <param name="End"></param>
/// <returns></returns>
public string GetMyResourceTaskListWithPage(int limit, int offset, string sort, string order, int UserID, string Title, string From, string To)
{
string orderby = " ORDER BY " + sort + " " + order;
string where = "SL.ExecutiveByID = @ExecutiveByID";
if (!string.IsNullOrEmpty(Title))
{
where += " AND R.Title LIKE '%" + Title.Replace("'", "''") + "%'";
}
DateTime dtFrom, dtTo;
if (DateTime.TryParse(From, out dtFrom))
{
where += " AND DATEDIFF(DAY, '" + dtFrom.ToString("yyyy-MM-dd") + "', R.EndDate) >= 0";
}
if (DateTime.TryParse(To, out dtTo))
{
where += " AND DATEDIFF(DAY, '" + dtTo.ToString("yyyy-MM-dd") + "', R.EndDate) <= 0";
}
int total;
List <ResourceRequestInfo> list = SqlMapDAL.CreateNameQuery("GetMyResourceTaskList")
.ReplaceText("1=1", where)
.SetParameter("ExecutiveByID", UserID)
.AppendText(orderby)
.ListEntityByPage <ResourceRequestInfo>(offset + 1, limit, out total);
return("{\"total\":" + total + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}");
}
/// <summary>
/// 获取流程指定步骤
/// </summary>
/// <param name="RefID">业务单据ID</param>
/// <param name="RefType">业务单据类别</param>
/// <param name="StepNum">步骤序号</param>
/// <returns></returns>
public ProcessStepEntityInfo GetProcessStep(long RefID, string RefType, int StepNum)
{
return(SqlMapDAL.CreateNameQuery("GetProcessStepByRef")
.SetParameter("RefID", RefID)
.SetParameter("RefType", RefType)
.SetParameter("StepNum", StepNum)
.Entity <ProcessStepEntityInfo>());
}
public void UploadChnnalPhoto(int ChnId, bool IsLeaf, byte[] photo)
{
SqlMapDAL.CreateNameQuery("UploadChnnalPhoto", true)
.SetParameter("ChnOrLeafId", ChnId)
.SetParameter("IsChn", IsLeaf ? 0 : 1)
.SetParameter("Photo", photo)
.ExecuteNonQuery();
}
public List <ChannelInfo> GetLeafs(int chnId, bool onlyCensor)
{
return
(SqlMapDAL.CreateNameQuery("GetLeafs")
.SetParameter("chnId", chnId)
.SetParameter("censor", onlyCensor)
.ListEntity <ChannelInfo>());
}
public List <ChannelInfo> GetChildrenChannel(int chnid, bool onlyCensor)
{
return
(SqlMapDAL.CreateNameQuery("GetChildrenChannelInfo")
.SetParameter("parentid", chnid)
.SetParameter("censor", onlyCensor)
.ListEntity <ChannelInfo>());
}
public void AddDocImportRecord(long docId, string subject, long drcnetDocId)
{
SqlMapDAL.CreateNameQuery("AddDocImportRecord")
.SetParameter("docid", docId)
.SetParameter("subject", subject)
.SetParameter("drcnetDocId", drcnetDocId)
.ExecuteNonQuery();
}
/// <summary>
/// 打回，回到上一步
/// </summary>
/// <param name="ProcessEntityID">流程实例ID</param>
/// <param name="Status">状态(打回后流程实例的状态)</param>
/// <param name="ExecutiveByID"></param>
/// <param name="ExecutiveBy"></param>
public void SetApproveStatusFail(Guid ProcessEntityID, string Status, int ExecutiveByID, string ExecutiveBy)
{
SqlMapDAL.CreateNameQuery("SetApproveStatusFail")
.SetParameter("ProcessEntityID", ProcessEntityID)
.SetParameter("Status", Status)
.SetParameter("ExecutiveByID", ExecutiveByID)
.SetParameter("ExecutiveBy", ExecutiveBy)
.ExecuteNonQuery();
}
public bool CheckReportTag(long docId, string tagName)
{
object obj = SqlMapDAL.CreateNameQuery("CheckReportTag")
.SetParameter("DocId", docId)
.SetParameter("TagName", tagName)
.ExecuteScalar();
return(obj == null);
}
public bool CheckLeafTagName(int leafid, string tagName)
{
var obj = SqlMapDAL.CreateNameQuery("CheckLeafTagName")
.SetParameter("TagName", tagName)
.SetParameter("LeafId", leafid)
.ExecuteScalar();
return(obj == null ? false : true);
}
public bool CheckReportSubject(string subject, long docId)
{
object obj = SqlMapDAL.CreateNameQuery("CheckReportSubject")
.SetParameter("Subject", subject)
.SetParameter("DocId", docId)
.ExecuteScalar();
return(obj == null);
}
/// <summary>
/// 初始化审批实例
/// </summary>
/// <param name="RefID">业务单据ID</param>
/// <param name="RefName">业务单据名称</param>
/// <param name="ProcessModelName">流程模板名称</param>
/// <returns>流程实例ID</returns>
public string Initialize(Int64 RefID, string RefName, string RefType)
{
object obj = SqlMapDAL.CreateNameQuery("ProcessInit")
.SetParameter("RefID", RefID)
.SetParameter("RefName", RefName)
.SetParameter("Name", RefType)
.ExecuteScalar();
return(obj.ToString());
}
public List <ReportBasicInfo> GetReportListByChnIdForHome(int chnId, int num)
{
string sqlCondition = "";
List <ReportBasicInfo> list = new List <ReportBasicInfo> ();
list = SqlMapDAL.CreateNameQuery("GetReportListByChnIdForHome")
.AppendText(sqlCondition)
.SetParameter("ChnId", chnId)
.SetParameter("Num", num).ListEntity <ReportBasicInfo>();
return(list);
}
/// <summary>
/// 更新单据状态
/// </summary>
/// <param name="RequestID"></param>
/// <param name="Status"></param>
/// <returns></returns>
private bool UpdateRequestStatus(long RequestID, int Status)
{
string sql = @"UPDATE dbo.RS_Request SET Status = @Status, LastUpdateDate = GETDATE() WHERE RequestID = @RequestID";
SqlMapDAL.CreateNameQuery("QueryDb")
.ReplaceText("{0}", sql)
.SetParameter("RequestID", RequestID)
.SetParameter("Status", Status)
.ExecuteNonQuery();
return(true);
}
private OuterUserInfo GetOuterUserInfoByUserID(int userId)
{
OuterUserInfo info = new OuterUserInfo();
info = SqlMapDAL.CreateNameQuery("GetOuterUserInfoByUserID").SetParameter("userId", userId).ListEntity <OuterUserInfo>().FirstOrDefault();
if (info != null)
{
info.Roles = SqlMapDAL.CreateNameQuery("GetRolesByUserID").SetParameter("userId", userId).ListEntity <RoleInfo>();
}
return(info);
}
/// <summary>
/// 通过，进入下一步
/// </summary>
/// <param name="stepInfo"></param>
public void SetApproveStatusApprove(Guid ProcessEntityID, string Status, int ExecutiveByID, string ExecutiveBy, int nextUserID, string nextUserName)
{
SqlMapDAL.CreateNameQuery("SetApproveStatusApprove")
.SetParameter("ProcessEntityID", ProcessEntityID)
.SetParameter("Status", Status)
.SetParameter("ExecutiveByID", ExecutiveByID)
.SetParameter("ExecutiveBy", ExecutiveBy)
.SetParameter("NextUserID", nextUserID)
.SetParameter("NextUserName", nextUserName)
.ExecuteNonQuery();
}
public bool RemoveleafTag(int leafid, string tagName)
{
try
{
SqlMapDAL.CreateNameQuery("RemoveleafTag")
.SetParameter("TagName", tagName)
.SetParameter("LeafId", leafid)
.ExecuteNonQuery();
return(true);
}
catch { return(false); }
}
public int InsertComment(long DocId, bool IsAnonymous, int UserId, string UserName, string Content, long ParentId)
{
string tt = SqlMapDAL.CreateNameQuery("InsertComment")
.SetParameter("DocId", DocId)
.SetParameter("IsAnonymous", IsAnonymous)
.SetParameter("UserId", UserId)
.SetParameter("UserName", UserName)
.SetParameter("Content", Content)
.SetParameter("ParentId", ParentId).ExecuteScalar().ToString();
return(Convert.ToInt32(tt));
}
public bool AddleafTag(int leafid, string tagName, int orderNumber = 0)
{
try
{
SqlMapDAL.CreateNameQuery("AddleafTag")
.SetParameter("TagName", tagName)
.SetParameter("LeafId", leafid)
.SetParameter("OrderNumber", orderNumber)
.ExecuteNonQuery();
return(true);
}
catch { return(false); }
}
public bool EditLeafTag(int leafid, string newTagName, string oldTagName, int OrderNumber = 0)
{
try
{
SqlMapDAL.CreateNameQuery("updateleafTag")
.SetParameter("newTagName", newTagName)
.SetParameter("oldTagName", oldTagName)
.SetParameter("LeafId", leafid)
.SetParameter("OrderNumber", OrderNumber)
.ExecuteNonQuery();
return(true);
}
catch { return(false); }
}
//删除栏目（删子栏目(状态置1)、本栏目包含的叶子关系状态置1 （子栏目及包含的叶子关系自动不可见）
public bool DelChannelInfo(int chnId)
{
bool result = false;
try
{
SqlMapDAL.CreateNameQuery("DelChannel", true)
.SetParameter("ChnId", chnId)
.ExecuteNonQuery();
result = true;
}
catch (Exception e) { result = false; }
return(result);
}
/// <summary>
/// 更新流程操作日志
/// </summary>
/// <param name="logInfo"></param>
public void UpdateLog(ProcessStepLogInfo logInfo)
{
SqlMapDAL.CreateNameQuery("UpdateLog")
.SetParameter("ExecutiveByID", logInfo.ExecutiveByID)
.SetParameter("ExecutiveBy", logInfo.ExecutiveBy)
.SetParameter("ExecutiveTime", logInfo.ExecutiveTime)
.SetParameter("Content", logInfo.Content)
.SetParameter("Conclusion", logInfo.Conclusion)
.SetParameter("RefIDType", logInfo.RefIDType)
.SetParameter("StepName", logInfo.StepName)
.SetParameter("StepNum", logInfo.StepNum)
.SetParameter("Status", logInfo.Status)
.SetParameter("logID", logInfo.logID)
.ExecuteNonQuery();
}
//删除叶子(要明确哪个栏目下的叶子， 关系状态置1。 叶子表状态不能改：防止该叶子属于多个频道)
public bool DeltLeafInfo(int chnId, int leafid)
{
bool result = false;
try
{
SqlMapDAL.CreateNameQuery("DelLeaf")
.SetParameter("ChnId", chnId)
.SetParameter("LeafId", leafid)
.ExecuteNonQuery();
result = true;
}
catch (Exception e) { result = false; }
return(result);
}
