//public DbFactory dbFactory = new DbFactory(DbFactory.DbFactoryType.SQLSERVER);
protected override IDataParameter[] GetSaveModelIDataParameter(UserInfo model)
{
dbFactory.dbF.CreateParameters(32);
dbFactory.dbF.AddParameters(0, "@bResult", SqlDbType.Int, 0);
dbFactory.dbF.AddParameters(1, "@ErrorMsg", SqlDbType.NVarChar, 1000);
dbFactory.dbF.AddParameters(2, "@v_ID", model.ID.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(3, "@v_UserNo", model.UserNo.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(4, "@v_UserName", model.UserName.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(5, "@v_Password", Secretkey.JiaMi(model.PassWord).ToOracleValue(), 0);
dbFactory.dbF.AddParameters(6, "@v_UserType", model.UserType.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(7, "@v_PinYin", model.PinYin.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(8, "@v_Duty", model.Duty.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(9, "@v_Tel", model.Tel.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(10, "@v_Mobile", model.Mobile.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(11, "@v_Email", model.Email.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(12, "@v_Sex", model.Sex.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(13, "@v_IsPick", model.IsPick.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(14, "@v_IsReceive", model.IsReceive.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(15, "@v_IsQuality", model.IsQuality.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(16, "@v_UserStatus", model.UserStatus.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(17, "@v_Address", model.Address.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(18, "@v_GroupCode", model.GroupCode.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(19, "@v_WarehouseCode", model.WarehouseCode.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(20, "@v_Description", model.Description.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(21, "@v_LoginIP", model.LoginIP.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(22, "@v_LoginTime", model.LoginTime.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(23, "@v_IsDel", model.IsDel.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(24, "@v_Creater", model.Creater.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(25, "@v_CreateTime", model.CreateTime.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(26, "@v_Modifyer", model.Modifyer.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(27, "@v_ModifyTime", model.ModifyTime.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(28, "@v_IsPickLeader", model.IsPickLeader.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(29, "@v_CYAccount", model.CYAccount.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(30, "@v_CXAccount", model.CXAccount.ToOracleValue(), 0);
dbFactory.dbF.AddParameters(31, "@v_FCAccount", model.FCAccount.ToOracleValue(), 0);
dbFactory.dbF.Parameters[0].Direction = System.Data.ParameterDirection.Output;
dbFactory.dbF.Parameters[1].Direction = System.Data.ParameterDirection.Output;
dbFactory.dbF.Parameters[2].Direction = System.Data.ParameterDirection.InputOutput;
//dbFactory.dbF.Parameters[11].Direction = System.Data.ParameterDirection.InputOutput;
//dbFactory.dbF.Parameters[13].Direction = System.Data.ParameterDirection.InputOutput;
return(dbFactory.dbF.Parameters);
//throw new NotImplementedException();
//OracleParameter[] param = new OracleParameter[]{
// new OracleParameter("@bResult",OracleDbType.Int32),
// new OracleParameter("@ErrorMsg",OracleDbType.NVarchar2,1000),
// new OracleParameter("@v_ID", model.ID.ToOracleValue()),
// new OracleParameter("@v_UserNo", model.UserNo.ToOracleValue()),
// new OracleParameter("@v_UserName", model.UserName.ToOracleValue()),
// new OracleParameter("@v_Password", Secretkey.JiaMi(model.PassWord)),
// new OracleParameter("@v_UserType", model.UserType.ToOracleValue()),
// new OracleParameter("@v_PinYin", model.PinYin.ToOracleValue()),
// new OracleParameter("@v_Duty", model.Duty.ToOracleValue()),
// new OracleParameter("@v_Tel", model.Tel.ToOracleValue()),
// new OracleParameter("@v_Mobile", model.Mobile.ToOracleValue()),
// new OracleParameter("@v_Email", model.Email.ToOracleValue()),
// new OracleParameter("@v_Sex", model.Sex.ToOracleValue()),
// new OracleParameter("@v_IsPick", model.IsPick.ToOracleValue()),
// new OracleParameter("@v_IsReceive", model.IsReceive.ToOracleValue()),
// new OracleParameter("@v_IsQuality", model.IsQuality.ToOracleValue()),
// new OracleParameter("@v_UserStatus", model.UserStatus.ToOracleValue()),
// new OracleParameter("@v_Address", model.Address.ToOracleValue()),
// new OracleParameter("@v_GroupCode", model.GroupCode.ToOracleValue()),
// new OracleParameter("@v_WarehouseCode", model.WarehouseCode.ToOracleValue()),
// new OracleParameter("@v_Description", model.Description.ToOracleValue()),
// new OracleParameter("@v_LoginIP", model.LoginIP.ToOracleValue()),
// new OracleParameter("@v_LoginTime", model.LoginTime.ToOracleValue()),
// new OracleParameter("@v_IsDel", model.IsDel.ToOracleValue()),
// new OracleParameter("@v_Creater", model.Creater.ToOracleValue()),
// new OracleParameter("@v_CreateTime", model.CreateTime.ToOracleValue()),
// new OracleParameter("@v_Modifyer", model.Modifyer.ToOracleValue()),
// new OracleParameter("@v_ModifyTime", model.ModifyTime.ToOracleValue()),
// new OracleParameter("@v_IsPickLeader", model.PickLeader==false ? 1 : 2 ),
// new OracleParameter("@v_CYAccount", model.CYAccount.ToOracleValue()),
// new OracleParameter("@v_CXAccount", model.CXAccount.ToOracleValue()),
// new OracleParameter("@v_FCAccount", model.FCAccount.ToOracleValue()),
// };
//param[0].Direction = System.Data.ParameterDirection.Output;
//param[1].Direction = System.Data.ParameterDirection.Output;
//param[2].Direction = System.Data.ParameterDirection.InputOutput;
//return param;
}
protected override UserInfo ToModel(IDataReader reader)
{
UserInfo t_user = new UserInfo();
t_user.ID = dbFactory.ToModelValue(reader, "ID").ToInt32();
t_user.UserNo = (string)dbFactory.ToModelValue(reader, "USERNO");
t_user.UserName = (string)dbFactory.ToModelValue(reader, "USERNAME");
t_user.PassWord = Secretkey.JieMi((string)dbFactory.ToModelValue(reader, "PASSWORD"));
t_user.UserType = dbFactory.ToModelValue(reader, "USERTYPE").ToInt32();
t_user.PinYin = (string)dbFactory.ToModelValue(reader, "PINYIN");
t_user.Duty = (string)dbFactory.ToModelValue(reader, "DUTY");
t_user.Tel = (string)dbFactory.ToModelValue(reader, "TEL");
t_user.Mobile = (string)dbFactory.ToModelValue(reader, "MOBILE");
t_user.Email = (string)dbFactory.ToModelValue(reader, "EMAIL");
t_user.Sex = dbFactory.ToModelValue(reader, "SEX").ToInt32();
t_user.IsPick = dbFactory.ToModelValue(reader, "ISPICK").ToInt32();
t_user.IsReceive = dbFactory.ToModelValue(reader, "ISRECEIVE").ToInt32();
t_user.IsQuality = dbFactory.ToModelValue(reader, "ISQUALITY").ToInt32();
t_user.UserStatus = dbFactory.ToModelValue(reader, "USERSTATUS").ToInt32();
t_user.Address = (string)dbFactory.ToModelValue(reader, "ADDRESS");
t_user.GroupCode = (string)dbFactory.ToModelValue(reader, "GROUPCODE");
t_user.WarehouseCode = (string)dbFactory.ToModelValue(reader, "WAREHOUSECODE");
t_user.Description = (string)dbFactory.ToModelValue(reader, "DESCRIPTION");
t_user.LoginIP = (string)dbFactory.ToModelValue(reader, "LOGINIP");
t_user.LoginTime = (DateTime?)dbFactory.ToModelValue(reader, "LOGINTIME");
t_user.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToDecimal();
t_user.Creater = (string)dbFactory.ToModelValue(reader, "CREATER");
t_user.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME");
t_user.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER");
t_user.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME");
t_user.LoginDevice = (string)dbFactory.ToModelValue(reader, "LOGINDEVICE");
t_user.Deviceversion = (string)dbFactory.ToModelValue(reader, "DEVICEVERSION");
if (Common_Func.readerExists(reader, "IsAdmin"))
{
t_user.BIsAdmin = reader["IsAdmin"].ToBoolean();
}
if (Common_Func.readerExists(reader, "StrUserType"))
{
t_user.StrUserType = reader["StrUserType"].ToDBString();
}
if (Common_Func.readerExists(reader, "StrUserStatus"))
{
t_user.StrUserStatus = reader["StrUserStatus"].ToDBString();
}
if (Common_Func.readerExists(reader, "StrSex"))
{
t_user.StrSex = reader["StrSex"].ToDBString();
}
if (Common_Func.readerExists(reader, "GroupName"))
{
t_user.GroupName = reader["GroupName"].ToDBString();
}
if (Common_Func.readerExists(reader, "WarehouseName"))
{
t_user.WarehouseName = reader["WarehouseName"].ToDBString();
}
t_user.RePassword = t_user.PassWord;
t_user.StrIsAdmin = t_user.BIsAdmin ? "管理员" : "标准用户";
t_user.StrIsPick = t_user.IsPick == 1 ? "拣货" : "不拣货";
t_user.StrIsReceive = t_user.IsReceive == 1 ? "收货" : "不收货";
t_user.BIsOnline = !string.IsNullOrEmpty(t_user.LoginIP);
t_user.IsOnline = t_user.BIsOnline.ToInt32();
t_user.StrCreateTime = t_user.CreateTime.ToShowTime();
t_user.StrModifyTime = t_user.ModifyTime.ToShowTime();
t_user.WarehouseID = dbFactory.ToModelValue(reader, "WAREHOUSECODE").ToInt32();
t_user.DisplayID = t_user.UserNo;
t_user.DisplayName = t_user.UserName;
t_user.IsPickLeader = dbFactory.ToModelValue(reader, "IsPickLeader").ToInt32();
t_user.StrIsPickLeader = t_user.IsPickLeader == 2 ? "是" : "否";
t_user.PickLeader = t_user.IsPickLeader == 2 ? true : false;
t_user.CYAccount = dbFactory.ToModelValue(reader, "CYAccount").ToDBString();
t_user.CXAccount = dbFactory.ToModelValue(reader, "CXAccount").ToDBString();
t_user.FCAccount = dbFactory.ToModelValue(reader, "FCAccount").ToDBString();
//t_user.PostAccount = GetPostAccount(t_user);
return(t_user);
}
