public static void SetDataGridView(DataGridView dgv, string setsql, bool disable, UserCache pcs, bool isFooter) { if (dgv == null) { return; } CtrlHelper.InitDataGridView(dgv, disable); CreateDataGridView(dgv, SqlBaseProvider.GetFullSetSql(setsql), pcs, isFooter); }
public static void CreateUpdateDeleteSysOnline(SysOnline item, DataProviderAction action) { if (item == null) { return; } SqlConnection conn = DBUtils.GetConnection(); SqlCommand cmd = DBUtils.GetCommand(); try { cmd.Transaction = conn.BeginTransaction(); ArrayList paras = new ArrayList(); paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, item.ManID)); paras.Add(DBUtils.MakeInParam("@Login_Date", SqlDbType.DateTime, Publics.GetDataDateTime(item.LoginDate))); paras.Add(DBUtils.MakeInParam("@Online_Date", SqlDbType.DateTime, Publics.GetDataDateTime(item.OnlineDate))); paras.Add(DBUtils.MakeInParam("@Menu_Code", SqlDbType.NVarChar, 4, item.MenuCode)); paras.Add(DBUtils.MakeInParam("@Reg_ID", SqlDbType.SmallInt, item.RegID)); paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action)); DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_CreateUpdateDelete_SysOnline", paras); if (action != DataProviderAction.Update) { SysLog sl = new SysLog(); sl.LogDate = DateTime.Now; sl.ManID = item.ManID; sl.LogAction = (short)LoginAction.Info; if (action == DataProviderAction.Create) { sl.LogContent = "登录系统"; } else { sl.LogContent = "退出系统"; } SqlBaseProvider.CreateUpdateDeleteSysLog(sl, DataProviderAction.Create); } cmd.Transaction.Commit(); } catch { cmd.Transaction.Rollback(); throw; } finally { DBUtils.SetDispose(conn, cmd); } }
public static UserCache GetLoginInfo(string manid, string reginfo, string password) { UserCache uc = new UserCache(); try { ArrayList paras = new ArrayList(); paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, manid)); SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Valid_Login", paras); if (reader.Read()) { uc.Company = SqlBaseProvider.PopulateSysCompany(reader); } if (reader.NextResult()) { if (reader.Read()) { uc.Dept = SqlBaseProvider.PopulateSysDept(reader); } } if (reader.NextResult()) { if (reader.Read()) { uc.Man = SqlBaseProvider.PopulateSysMan(reader); } } if (reader.NextResult()) { if (reader.Read()) { uc.Dept.DeptFlow = (short)reader["Dept_Flow"]; } } reader.Close(); } catch { } return(uc); }