public ActionResult Index(int?p)
{
Pager pager = new Pager();
pager.table = "CMSJixiao";
pager.strwhere = "1=1";
pager.PageSize = 20;
pager.PageNo = p ?? 1;
pager.FieldKey = "JixiaoId";
pager.FiledOrder = "JixiaoId Desc";
pager = CMSService.SelectAll("Jixiao", pager);
List <JixiaoDto> list = new List <JixiaoDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
JixiaoDto dto = JixiaoMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewBag.ZongCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "1=1", "Count(JixiaoId)");
ViewBag.ShenheCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='已审核'", "Count(JixiaoId)");
ViewBag.WeishenheCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='未通过'", "Count(JixiaoId)");
ViewBag.ZongFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "1=1", "SUM(JixiaoFenshu)");
ViewBag.ShenheFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='已审核'", "SUM(JixiaoFenshu)");
ViewBag.WeishenheFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='未通过'", "SUM(JixiaoFenshu)");
ViewData["Month"] = CommonTools.GetMontList();
return(View(pager.Entity));
}
public static JixiaoDto getDTO(DataRow dr)
{
JixiaoDto jixiaoDto = new JixiaoDto();
jixiaoDto.JixiaoId = int.Parse(dr["JixiaoId"].ToString());
jixiaoDto.JixiaoUser = dr["JixiaoUser"].ToString();
jixiaoDto.JixiaoForUser = dr["JixiaoForUser"].ToString();
jixiaoDto.JixiaoCategory = int.Parse(dr["JixiaoCategory"].ToString());
jixiaoDto.JixiaoParentCategory = int.Parse(dr["JixiaoParentCategory"].ToString());
jixiaoDto.JixiaoTime = DateTime.Parse(dr["JixiaoTime"].ToString());
jixiaoDto.JixiaoShenheTime = DateTime.Parse(dr["JixiaoShenheTime"].ToString());
jixiaoDto.JixiaoFenshu = double.Parse(dr["JixiaoFenshu"].ToString());
jixiaoDto.JixiaoRenwu = dr["JixiaoRenwu"].ToString();
jixiaoDto.JixiaoStatus = dr["JixiaoStatus"].ToString();
return(jixiaoDto);
}
public ActionResult Create(JixiaoModel model)
{
JixiaoDto dto = new JixiaoDto();
dto.JixiaoUser = model.JixiaoUser;
dto.JixiaoForUser = model.JixiaoForUser;
dto.JixiaoCategory = model.JixiaoCategory;
dto.JixiaoParentCategory = model.JixiaoParentCategory;
dto.JixiaoRenwu = model.JixiaoRenwu;
dto.JixiaoStatus = "已审核";
dto.JixiaoTime = System.DateTime.Now;
dto.JixiaoFenshu = MyService.GetFenshuByCategory(model.JixiaoCategory);
dto.JixiaoShenheTime = System.DateTime.Now;
string JsonString = JsonHelper.JsonSerializerBySingleData(dto);
Message msg = CMSService.Insert("Jixiao", JsonString);
return(RedirectTo("/Jixiao/Index", msg.MessageInfo));
}
public SqlParameter[] JsonStringToSqlParameter(string jsonString)
{
SqlParameter[] arParames = new SqlParameter[9];
JixiaoDto jixiaoDto = JsonHelper.JsonDeserializeBySingleData <JixiaoDto>(jsonString);
arParames[0] = new SqlParameter("@JixiaoUser", SqlDbType.VarChar, 50);
arParames[0].Value = jixiaoDto.JixiaoUser;
arParames[1] = new SqlParameter("@JixiaoForUser", SqlDbType.VarChar, 50);
arParames[1].Value = jixiaoDto.JixiaoForUser;
arParames[2] = new SqlParameter("@JixiaoParentCategory", SqlDbType.VarChar, 500);
arParames[2].Value = jixiaoDto.JixiaoParentCategory;
arParames[3] = new SqlParameter("@JixiaoCategory", SqlDbType.VarChar, 500);
arParames[3].Value = jixiaoDto.JixiaoCategory;
arParames[4] = new SqlParameter("@JixiaoRenwu", SqlDbType.VarChar, 5000);
arParames[4].Value = jixiaoDto.JixiaoRenwu;
arParames[5] = new SqlParameter("@JixiaoStatus", SqlDbType.VarChar, 50);
arParames[5].Value = jixiaoDto.JixiaoStatus;
arParames[6] = new SqlParameter("@JixiaoFenshu", SqlDbType.Real);
arParames[6].Value = jixiaoDto.JixiaoFenshu;
arParames[7] = new SqlParameter("@JixiaoTime", SqlDbType.DateTime);
arParames[7].Value = jixiaoDto.JixiaoTime;
arParames[8] = new SqlParameter("@JixiaoShenheTime", SqlDbType.DateTime);
arParames[8].Value = jixiaoDto.JixiaoShenheTime;
return(arParames);
}
