/// <summary>
/// 会议统计 id 为会议 ids 为是否陌生
/// </summary>
/// <returns></returns>
public ActionResult MeetingTJ(string id, string ids)
{
List <tb_gift> listorder = new List <tb_gift>();
if (id != null && ids != null)
{
SqlParameter[] pms =
{
new SqlParameter("@meeting", id),
new SqlParameter("@ms", ids)
};
MessasgeData mgdata = Datafun.MgfunctionData("Tj_rstj_poc", pms, "poc");
foreach (DataRow dr in mgdata.Mgdata.Rows)
{
tb_gift cbai = new tb_gift
{
UserName = dr["UserName"].ToString(),
Tel = dr["Tel"].ToString(),
Qdh = dr["Qdh"].ToString(),
Hongbao = dr["Hongbao"].ToString(),
Gift = dr["Gift"].ToString(),
Added1 = dr["sjrs"].ToString(),
Added2 = dr["yjrs"].ToString(),
};
listorder.Add(cbai);
}
;
}
ViewBag.id = id;
ViewBag.ids = ids;
return(View(listorder));
}
/// <summary>
/// 礼物详情单
/// </summary>
/// <returns></returns>
public ActionResult GiftInfor(string id)
{
MessasgeData mgdata = Datafun.MgfunctionData("select a.id,UserName,Tel,Qdh,Hongbao,Gift,b.MeetingName from tb_gift A left join tb_Meeting b on a.Meeting=b.id where a.isdel=0 and Meeting=@id", new SqlParameter("@id", id));
List <tb_gift> listorder = new List <tb_gift>();
foreach (DataRow dr in mgdata.Mgdata.Rows)
{
tb_gift cbai = new tb_gift
{
id = Convert.ToInt32(dr["id"].ToString()),
UserName = dr["UserName"].ToString(),
Tel = dr["Tel"].ToString(),
Qdh = dr["Qdh"].ToString(),
Hongbao = dr["Hongbao"].ToString(),
Gift = dr["Gift"].ToString(),
Added1 = dr["MeetingName"].ToString()
};
listorder.Add(cbai);
}
;
return(View(listorder));
}