public static bool Check(string funCode, bool f_IsCheck = true) { if (!USysInfo.F_Manager && f_IsCheck) { var items = Rights.Where(it => it.FunCode == funCode).Count(); if (items == 0) { MessageErp.ErrorMessage(ErpUIText.Get("ERP_RightErr")); return(false); } } if (!string.IsNullOrEmpty(funCode)) { var _log = new MS_Log() { DBCode = USysInfo.DBCode, UserCode = USysInfo.UserCode, ClientID = USysInfo.ClientID, FunCode = funCode, IP = USysInfo.IP }; DS_Bill.Add(USysInfo.DBERP, USysInfo.LgIndex, _log, geted => { if (geted.HasError) { geted.MarkErrorAsHandled(); return; } }, null); } return(true); }
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t) { MS_Log model = t as MS_Log; StringBuilder strSql = new StringBuilder(); strSql.Append("delete from S_Log "); strSql.Append("where LogTime<=DATEADD(mm,-1,GETDATE());"); strSql.Append("insert into S_Log("); strSql.Append("ID,LogTime,FunCode,UserCode,DBCode,IP,ClientID)"); strSql.Append(" values ("); strSql.Append("@ID,@LogTime,@FunCode,@UserCode,@DBCode,@IP,@ClientID)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@LogTime", SqlDbType.DateTime), new SqlParameter("@FunCode", SqlDbType.VarChar, 50), new SqlParameter("@UserCode", SqlDbType.VarChar, 50), new SqlParameter("@DBCode", SqlDbType.VarChar, 50), new SqlParameter("@IP", SqlDbType.VarChar, 50), new SqlParameter("@ClientID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = DateTime.Now; parameters[2].Value = model.FunCode; parameters[3].Value = model.UserCode; parameters[4].Value = model.DBCode; parameters[5].Value = model.IP; parameters[6].Value = model.ClientID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void Update <T>(string dbCode, int lgIndex, MS_Log t) { bll.Update(dbCode, lgIndex, t, false); }
public string Add(string dbCode, int lgIndex, MS_Log t) { return(bll.Add(dbCode, lgIndex, t, false)); }