public ActionResult ShowAllWeaponList(int sort = 0)
{
WeaponUserList weaponuser = new WeaponUserList();
weaponuser.UserID = 0;
weaponuser.StatusID = 1;
weaponuser.Sort = sort;
List <WeaponUserList> lists = WeapDesignBll.GetWeaponUserList(weaponuser);
return(Jsonp(ErrorCode.Succuess, lists));
}
public ActionResult ShowWeaponList()
{
if (!User.Identity.IsAuthenticated)
{
return(Jsonp(ErrorCode.LoginError, null));
}
else
{
WeaponUserList weaponuser = new WeaponUserList();
weaponuser.UserID = UserCookie.UserID;
weaponuser.Sort = 0;
List <WeaponUserList> lists = WeapDesignBll.GetWeaponUserList(weaponuser);
return(Jsonp(ErrorCode.Succuess, lists));
}
}
/// <summary>
/// 列表
/// </summary>
/// <param name="searchSort">用来搜索的实例</param>
/// <returns></returns>
public ActionResult WeaponAllUserList(CommonLibs.Common.DataPage dp, WeaponUserList model, int?AreaID)
{
ViewBag.AreaID = GetGameAreaList();
ViewBag.StatusID = GetWeaponStatusList();
model.AreaID = AreaID ?? -1;
List <WeaponUserList> lists = new List <WeaponUserList>();
if (Request["btnExportExcel"] == null)//导出Excel
{
lists = _adminBLL.GetWeaponAllUserList(ref dp, model);
GetDataPage(dp);
}
else
{
dp.PageSize = 0;
lists = _adminBLL.GetWeaponAllUserList(ref dp, model);
string fileName = "nothing";
if (lists.Count() > 0)
{
fileName = "WeaponAllUserList" + lists.Count() + "_Item";
}
Dictionary <string, Func <WeaponUserList, string> > showFields = new Dictionary <string, Func <WeaponUserList, string> >();
showFields.Add(WeaponUserList.WeaponIDField, z => "'" + z.WeaponID.ToString());
showFields.Add(WeaponUserList.WeaponNameField, z => "'" + z.WeaponName.ToString());
showFields.Add(WeaponUserList.WeaTypeField, z => "'" + z.WeaType.ToString());
showFields.Add(WeaponUserList.WeaponDescField, z => "'" + z.WeaponDesc.ToString());
showFields.Add(WeaponUserList.UserIDField, z => "'" + z.UserID.ToString());
showFields.Add(WeaponUserList.LoginNameField, z => "'" + z.LoginName.ToString());
showFields.Add(WeaponUserList.AreaNameField, z => "'" + z.AreaName.ToString());
showFields.Add(WeaponUserList.AvatarNameField, z => "'" + z.AvatarName.ToString());
showFields.Add(WeaponUserList.ShowPraiseField, z => "'" + z.ShowPraise.ToString());
showFields.Add(WeaponUserList.CreateTSField, z => "'" + z.CreateTS.ToString());
showFields.Add(WeaponUserList.UpdateTSField, z => "'" + z.UpdateTS.ToString());
showFields.Add(WeaponUserList.StatusTypeField, z => "'" + z.StatusType.ToString());
showFields.Add(WeaponUserList.ReasonField, z => "'" + z.Reason.ToString());
showFields.Add(WeaponUserList.FirstNameField, z => "'" + z.FirstName.ToString());
showFields.Add(WeaponUserList.GenderField, z => "'" + z.Gender.ToString());
showFields.Add(WeaponUserList.ContactMethodField, z => "'" + z.ContactMethod.ToString());
ObjectUtil.Common.ExcelHelper2 <WeaponUserList> elh = new ObjectUtil.Common.ExcelHelper2 <WeaponUserList>(lists, null, showFields);
elh.FileWebSaveAs(Response, fileName);
}
//记录日志
Log(string.Format("查看[WeaponUserList]列表页面 搜索数据:{0}", model.ToString()));
return(View(lists));
}
public List <WeaponUserList> GetWeaponAllUserList(ref DataPage dp, WeaponUserList weaponuserlist)
{
_admin = new WeaponDesignAdminService.WeaponDesignAdminServiceClient();
List <WeaponUserList> lists = new List <WeaponUserList>();
try
{
lists = _admin.GetWeaponAllUserList(ref dp, weaponuserlist);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetWeaponUserList 获取武器信息失败");
return(lists);
}
}
public List <WeaponUserList> GetWeaponUserList(WeaponUserList weaponuserlist)
{
_client = new WeaponDesignService.WeaponDesignServiceClient();
List <WeaponUserList> lists = new List <WeaponUserList>();
try
{
lists = _client.GetWeaponUserList(weaponuserlist);
_client.Close();
return(lists);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "GetWeaponUserList 获取指定用户的武器失败");
return(lists);
}
}
/// <summary>
/// 获取 WeaponList 全部数据
/// </summary>
/// Create By zhouqi
/// 2015/11/26 18:03:57
/// <returns></returns>
public List <WeaponUserList> GetWeaponUserList(WeaponUserList weaponuserlist)
{
DbCommand cmd = DB.GetStoredProcCommand("WeaponList_GetAll");
List <WeaponUserList> weaponListList = new List <WeaponUserList>();
DB.AddInParameter(cmd, WeaponUserList.UserIDField, DbType.Int64, weaponuserlist.UserID);
DB.AddInParameter(cmd, WeaponUserList.StatusIDField, DbType.Int32, weaponuserlist.StatusID);
DB.AddInParameter(cmd, WeaponUserList.SortField, DbType.Int32, weaponuserlist.Sort);
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coWeaponID = dr.GetOrdinal(WeaponUserList.WeaponIDField);
int coWeaponName = dr.GetOrdinal(WeaponUserList.WeaponNameField);
int coContactMethod = dr.GetOrdinal(WeaponUserList.ContactMethodField);
int coWeaponDesc = dr.GetOrdinal(WeaponUserList.WeaponDescField);
int coShowPraise = dr.GetOrdinal(WeaponUserList.ShowPraiseField);
int coPicAddress = dr.GetOrdinal(WeaponUserList.PicAddressField);
int coSpicAddress = dr.GetOrdinal(WeaponUserList.SpicAddressField);
int coLength = dr.GetOrdinal(WeaponUserList.LengthField);
int coWidth = dr.GetOrdinal(WeaponUserList.WidthField);
int coSLength = dr.GetOrdinal(WeaponUserList.SLengthField);
int coSWidth = dr.GetOrdinal(WeaponUserList.SWidthField);
int coCreateTS = dr.GetOrdinal(WeaponUserList.CreateTSField);
int coUpdateTS = dr.GetOrdinal(WeaponUserList.UpdateTSField);
int coAvatarName = dr.GetOrdinal(WeaponUserList.AvatarNameField);
int coAreaName = dr.GetOrdinal(WeaponUserList.AreaNameField);
int coStatusType = dr.GetOrdinal(WeaponUserList.StatusTypeField);
int coUserID = dr.GetOrdinal(WeaponUserList.UserIDField);
int coReason = dr.GetOrdinal(WeaponUserList.ReasonField);
int coWeaType = dr.GetOrdinal(WeaponUserList.WeaTypeField);
int coLoginName = dr.GetOrdinal(WeaponUserList.LoginNameField);
int coTotalCom = dr.GetOrdinal(WeaponUserList.TotalComField);
int coFirstName = dr.GetOrdinal(WeaponUserList.FirstNameField);
int coGender = dr.GetOrdinal(WeaponUserList.GenderField);
while (dr.Read())
{
WeaponUserList weaponuserList = new WeaponUserList();
weaponuserList.WeaponID = dr.IsDBNull(coWeaponID) ? (int)0 : dr.GetInt32(coWeaponID);
weaponuserList.WeaponName = dr.IsDBNull(coWeaponName) ? string.Empty : dr.GetString(coWeaponName);
weaponuserList.ContactMethod = dr.IsDBNull(coContactMethod) ? string.Empty : dr.GetString(coContactMethod);
weaponuserList.WeaponDesc = dr.IsDBNull(coWeaponDesc) ? string.Empty : dr.GetString(coWeaponDesc);
weaponuserList.ShowPraise = dr.IsDBNull(coShowPraise) ? (int)0 : dr.GetInt32(coShowPraise);
weaponuserList.PicAddress = dr.IsDBNull(coPicAddress) ? string.Empty : dr.GetString(coPicAddress);
weaponuserList.SpicAddress = dr.IsDBNull(coSpicAddress) ? string.Empty : dr.GetString(coSpicAddress);
weaponuserList.Length = dr.IsDBNull(coLength) ? (int)0 : dr.GetInt32(coLength);
weaponuserList.Width = dr.IsDBNull(coWidth) ? (int)0 : dr.GetInt32(coWidth);
weaponuserList.SLength = dr.IsDBNull(coSLength) ? (int)0 : dr.GetInt32(coSLength);
weaponuserList.SWidth = dr.IsDBNull(coSWidth) ? (int)0 : dr.GetInt32(coSWidth);
weaponuserList.CreateTS = dr.IsDBNull(coCreateTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coCreateTS);
weaponuserList.UpdateTS = dr.IsDBNull(coUpdateTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coUpdateTS);
weaponuserList.AvatarName = dr.IsDBNull(coAvatarName) ? string.Empty : dr.GetString(coAvatarName);
weaponuserList.AreaName = dr.IsDBNull(coAreaName) ? string.Empty : dr.GetString(coAreaName);
weaponuserList.StatusType = dr.IsDBNull(coStatusType) ? string.Empty : dr.GetString(coStatusType);
weaponuserList.UserID = dr.IsDBNull(coUserID) ? (long)0 : dr.GetInt64(coUserID);
weaponuserList.Reason = dr.IsDBNull(coReason) ? string.Empty : dr.GetString(coReason);
weaponuserList.WeaType = dr.IsDBNull(coWeaType) ? string.Empty : dr.GetString(coWeaType);
weaponuserList.LoginName = dr.IsDBNull(coLoginName) ? string.Empty : dr.GetString(coLoginName);
weaponuserList.TotalCom = dr.IsDBNull(coTotalCom) ? (int)0 : dr.GetInt32(coTotalCom);
weaponuserList.FirstName = dr.IsDBNull(coFirstName) ? string.Empty : dr.GetString(coFirstName);
weaponuserList.Gender = dr.IsDBNull(coGender) ? string.Empty : dr.GetString(coGender);
weaponListList.Add(weaponuserList);
}
}
}
return(weaponListList);
}
public List <WeaponUserList> GetWeaponAllUserList(ref DataPage dp, WeaponUserList weaponuserlist)
{
return(_dal.GetWeaponAllUserList(ref dp, weaponuserlist));
}
public List <WeaponUserList> GetWeaponUserList(WeaponUserList weaponuserlist)
{
return(_dal.GetWeaponUserList(weaponuserlist));
}
/// <summary>
/// 获取 WeaponList 全部数据
/// </summary>
/// Create By zhouqi
/// 2015/11/26 18:03:57
/// <returns></returns>
public List <WeaponUserList> GetWeaponAllUserList(ref DataPage dp, WeaponUserList weaponuserlist)
{
DbCommand cmd = DB.GetStoredProcCommand("WeaponList_GetAllUsers");
string websitepath = AppSetting.GetString("WebsitePath");
List <WeaponUserList> weaponListList = new List <WeaponUserList>();
//翻页参数
DB.AddInParameter(cmd, DataPage.PageSizeField, DbType.Int32, dp.PageSize);
DB.AddInParameter(cmd, DataPage.PageIndexField, DbType.Int32, dp.PageIndex);
DB.AddParameter(cmd, DataPage.RowCountField, DbType.Int64, ParameterDirection.InputOutput, String.Empty, DataRowVersion.Default, dp.RowCount);
DB.AddInParameter(cmd, WeaponUserList.AreaIDField, DbType.Int32, weaponuserlist.AreaID);
DB.AddInParameter(cmd, WeaponUserList.StatusIDField, DbType.Int32, weaponuserlist.StatusID);
DB.AddInParameter(cmd, WeaponUserList.UserIDField, DbType.Int64, weaponuserlist.UserID);
DB.AddInParameter(cmd, WeaponUserList.WeaponNameField, DbType.String, weaponuserlist.WeaponName);
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coWeaponID = dr.GetOrdinal(WeaponUserList.WeaponIDField);
int coWeaponName = dr.GetOrdinal(WeaponUserList.WeaponNameField);
int coContactMethod = dr.GetOrdinal(WeaponUserList.ContactMethodField);
int coWeaponDesc = dr.GetOrdinal(WeaponUserList.WeaponDescField);
int coShowPraise = dr.GetOrdinal(WeaponUserList.ShowPraiseField);
int coPicAddress = dr.GetOrdinal(WeaponUserList.PicAddressField);
int coSpicAddress = dr.GetOrdinal(WeaponUserList.SpicAddressField);
int coLength = dr.GetOrdinal(WeaponUserList.LengthField);
int coWidth = dr.GetOrdinal(WeaponUserList.WidthField);
int coSLength = dr.GetOrdinal(WeaponUserList.SLengthField);
int coSWidth = dr.GetOrdinal(WeaponUserList.SWidthField);
int coCreateTS = dr.GetOrdinal(WeaponUserList.CreateTSField);
int coUpdateTS = dr.GetOrdinal(WeaponUserList.UpdateTSField);
int coStatusID = dr.GetOrdinal(WeaponUserList.StatusIDField);
int coAvatarName = dr.GetOrdinal(WeaponUserList.AvatarNameField);
int coAreaName = dr.GetOrdinal(WeaponUserList.AreaNameField);
int coStatusType = dr.GetOrdinal(WeaponUserList.StatusTypeField);
int coUserID = dr.GetOrdinal(WeaponUserList.UserIDField);
int coReason = dr.GetOrdinal(WeaponUserList.ReasonField);
int coWeaType = dr.GetOrdinal(WeaponUserList.WeaTypeField);
int coAreaID = dr.GetOrdinal(WeaponUserList.AreaIDField);
int coLoginName = dr.GetOrdinal(WeaponUserList.LoginNameField);
int coFistName = dr.GetOrdinal(WeaponUserList.FirstNameField);
int coGender = dr.GetOrdinal(WeaponUserList.GenderField);
while (dr.Read())
{
WeaponUserList weaponuserList = new WeaponUserList();
weaponuserList.WeaponID = dr.IsDBNull(coWeaponID) ? (int)0 : dr.GetInt32(coWeaponID);
weaponuserList.WeaponName = dr.IsDBNull(coWeaponName) ? string.Empty : dr.GetString(coWeaponName);
weaponuserList.ContactMethod = dr.IsDBNull(coContactMethod) ? string.Empty : dr.GetString(coContactMethod);
weaponuserList.WeaponDesc = dr.IsDBNull(coWeaponDesc) ? string.Empty : dr.GetString(coWeaponDesc);
weaponuserList.ShowPraise = dr.IsDBNull(coShowPraise) ? (int)0 : dr.GetInt32(coShowPraise);
weaponuserList.PicAddress = dr.IsDBNull(coPicAddress) ? string.Empty : (websitepath + dr.GetString(coPicAddress));
weaponuserList.SpicAddress = dr.IsDBNull(coSpicAddress) ? string.Empty : (websitepath + dr.GetString(coSpicAddress));
weaponuserList.Length = dr.IsDBNull(coLength) ? (int)0 : dr.GetInt32(coLength);
weaponuserList.Width = dr.IsDBNull(coWidth) ? (int)0 : dr.GetInt32(coWidth);
weaponuserList.SLength = dr.IsDBNull(coSLength) ? (int)0 : dr.GetInt32(coSLength);
weaponuserList.SWidth = dr.IsDBNull(coSWidth) ? (int)0 : dr.GetInt32(coSWidth);
weaponuserList.CreateTS = dr.IsDBNull(coCreateTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coCreateTS);
weaponuserList.UpdateTS = dr.IsDBNull(coUpdateTS) ? (DateTime)SqlDateTime.Null : dr.GetDateTime(coUpdateTS);
weaponuserList.StatusID = dr.IsDBNull(coStatusID) ? (int)0 : dr.GetInt32(coStatusID);
weaponuserList.AvatarName = dr.IsDBNull(coAvatarName) ? string.Empty : dr.GetString(coAvatarName);
weaponuserList.AreaName = dr.IsDBNull(coAreaName) ? string.Empty : dr.GetString(coAreaName);
weaponuserList.StatusType = dr.IsDBNull(coStatusType) ? string.Empty : dr.GetString(coStatusType);
weaponuserList.UserID = dr.IsDBNull(coUserID) ? (long)0 : dr.GetInt64(coUserID);
weaponuserList.Reason = dr.IsDBNull(coReason) ? string.Empty : dr.GetString(coReason);
weaponuserList.WeaType = dr.IsDBNull(coWeaType) ? string.Empty : dr.GetString(coWeaType);
weaponuserList.AreaID = dr.IsDBNull(coAreaID) ? (int)0 : dr.GetInt32(coAreaID);
weaponuserList.LoginName = dr.IsDBNull(coLoginName) ? string.Empty : dr.GetString(coLoginName);
weaponuserList.FirstName = dr.IsDBNull(coFistName) ? string.Empty : dr.GetString(coFistName);
weaponuserList.Gender = dr.IsDBNull(coGender) ? string.Empty : dr.GetString(coGender);
weaponListList.Add(weaponuserList);
}
}
}
//获取翻页
dp.RowCount = Convert.ToInt64(DB.GetParameterValue(cmd, DataPage.RowCountField));
return(weaponListList);
}
