public static SysMan ValidAuth(string manid, string password)
{
SysMan item = new SysMan();
try
{
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, manid));
paras.Add(DBUtils.MakeInParam("@Password", SqlDbType.NVarChar, 50, Crypto.MD5Crypto(password)));
SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Valid_AuthMan", paras);
if (reader.Read())
{
item.ManID = reader["Man_ID"] as string;
item.ManName = reader["Man_Name"] as string;
item.DeptID = reader["Dept_ID"] as string;
item.ManLevel = (short)reader["Man_Level"];
item.ManType = (short)reader["Man_Type"];
item.IsLock = Convert.ToBoolean(reader["Is_Lock"]);
item.AuthBound = (short)reader["Auth_Bound"];
}
reader.Close();
}
catch
{
throw;
}
return(item);
}
public static void SaveSysMan(SysMan 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("@Man_Name", SqlDbType.NVarChar, 10, item.ManName));
paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, item.CoID));
paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 8, item.DeptID));
paras.Add(DBUtils.MakeInParam("@Man_Type", SqlDbType.SmallInt, item.ManType));
paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
paras.Add(DBUtils.MakeInParam("@Crt_Oper", SqlDbType.NVarChar, 6, item.CrtOper));
paras.Add(DBUtils.MakeInParam("@Man_Tele", SqlDbType.NVarChar, 30, item.ManTele));
paras.Add(DBUtils.MakeInParam("@Man_EMail", SqlDbType.NVarChar, 32, item.ManEMail));
paras.Add(DBUtils.MakeInParam("@Man_Date", SqlDbType.DateTime, Publics.GetDataDateTime(item.ManDate)));
paras.Add(DBUtils.MakeInParam("@Man_Level", SqlDbType.SmallInt, item.ManLevel));
paras.Add(DBUtils.MakeInParam("@Man_Title", SqlDbType.SmallInt, item.ManTitle));
paras.Add(DBUtils.MakeInParam("@Man_Sex", SqlDbType.SmallInt, item.ManSex));
paras.Add(DBUtils.MakeInParam("@Man_Status", SqlDbType.SmallInt, item.ManStatus));
paras.Add(DBUtils.MakeInParam("@Oper_Password", SqlDbType.NVarChar, 50, item.OperPassword));
paras.Add(DBUtils.MakeInParam("@Oper_Serial", SqlDbType.Int, item.OperSerial));
paras.Add(DBUtils.MakeInParam("@Work_Date", SqlDbType.NVarChar, 8, item.WorkDate));
paras.Add(DBUtils.MakeInParam("@Auth_Bound", SqlDbType.SmallInt, item.AuthBound));
paras.Add(DBUtils.MakeInParam("@Is_Admin", SqlDbType.Bit, item.IsAdmin));
paras.Add(DBUtils.MakeInParam("@Remark", SqlDbType.NVarChar, 20, item.Remark));
paras.Add(DBUtils.MakeInParam("@Pre_Work_Date", SqlDbType.NVarChar, 8, item.WorkDate));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysMan", paras);
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static SysMan PopulateSysMan(IDataReader reader)
{
SysMan item = new SysMan();
item.ManID = reader["Man_ID"] as string;
item.ManName = reader["Man_Name"] as string;
item.CoID = reader["Co_ID"] as string;
item.CoName = reader["Co_Name"] as string;
item.DeptID = reader["Dept_ID"] as string;
item.DeptName = reader["Dept_Name"] as string;
item.ManType = (short)reader["Man_Type"];
item.ManTypeName = reader["Man_Type_Name"] as string;
item.CrtDate = Convert.ToDateTime(reader["Crt_Date"]);
if (reader["Crt_Oper"] != DBNull.Value)
{
item.CrtOper = reader["Crt_Oper"] as string;
}
if (reader["Man_Tele"] != DBNull.Value)
{
item.ManTele = reader["Man_Tele"] as string;
}
if (reader["Man_EMail"] != DBNull.Value)
{
item.ManEMail = reader["Man_EMail"] as string;
}
if (reader["Man_Date"] != DBNull.Value)
{
item.ManDate = Convert.ToDateTime(reader["Man_Date"]);
}
item.ManLevel = (short)reader["Man_Level"];
item.ManLevelName = reader["Man_Level_Name"] as string;
item.ManTitle = (short)reader["Man_Title"];
item.ManTitleName = reader["Man_Title_Name"] as string;
item.ManSex = (short)reader["Man_Sex"];
item.ManSexName = reader["Man_Sex_Name"] as string;
item.ManStatus = (short)reader["Man_Status"];
item.ManStatusName = reader["Man_Status_Name"] as string;
item.OperPassword = reader["Oper_Password"] as string;
item.OperSerial = (int)reader["Oper_Serial"];
item.WorkDate = reader["Work_Date"] as string;
item.AuthBound = (short)reader["Auth_Bound"];
item.IsAdmin = Convert.ToBoolean(reader["Is_Admin"]);
if (reader["Remark"] != DBNull.Value)
{
item.Remark = reader["Remark"] as string;
}
item.PreWorkDate = reader["Pre_Work_Date"] as string;
item.IsLock = Convert.ToBoolean(reader["Is_Lock"]);
item.IsFirst = Convert.ToBoolean(reader["Is_First"]);
return(item);
}
public static SysMan GetSysManByType(string deptid, short type)
{
SysMan item = new SysMan();
try
{
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 10, deptid));
paras.Add(DBUtils.MakeInParam("@Man_Type", SqlDbType.SmallInt, type));
SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_ManByType", paras);
if (reader.Read())
{
item = PopulateSysMan(reader);
}
reader.Close();
}
catch { throw; }
return(item);
}
public static SysMan GetSysMan(string manid)
{
SysMan item = new SysMan();
try
{
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, manid));
paras.Add(DBUtils.MakeInParam("@Get_Action", SqlDbType.NVarChar, 10, DataGetAction.Row.ToString().ToLower()));
SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_SysMan", paras);
if (reader.Read())
{
item = PopulateSysMan(reader);
}
reader.Close();
}
catch { throw; }
return(item);
}