public ActionResult GetProvince()
{
string ReturnValue = string.Empty;
MessasgeData mgdata = Datafun.MgfunctionData("select ccode,cname from dbo.bm_region where arealevel=1");
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
public ActionResult GetQuestion()
{
string ReturnValue = string.Empty;
MessasgeData mgdata = Datafun.MgfunctionData("select id,Question from dbo.tb_question where isdel=0");
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
public ActionResult GetBank()
{
string ReturnValue = string.Empty;
MessasgeData mgdata = Datafun.MgfunctionData("select distinct Bank from tb_InsertMeeting where Meeting=@Meeting and Bank <>''", new SqlParameter("@Meeting", LgUser.Meetting));
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
public ActionResult GetMeeting()
{
string ReturnValue = string.Empty;
MessasgeData mgdata = Datafun.MgfunctionData(" select id,MeetingName from tb_Meeting where isdel=0 ");
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
public ActionResult GetCity(string id)
{
string ReturnValue = string.Empty;
MessasgeData mgdata = Datafun.MgfunctionData("select ccode,cname from dbo.bm_region where pcode=@id", new SqlParameter("@id", id));
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
public ActionResult GetMeetingFen()
{
string ReturnValue = string.Empty;
string sql = "";
if (LgUser.Meetting == "")
{
sql = "select id,MeetingName from tb_Meeting where isdel=0";
}
else
{
sql = "select id,MeetingName from tb_Meeting where isdel=0 and id=@id";
}
MessasgeData mgdata = Datafun.MgfunctionData(sql, new SqlParameter("@id", LgUser.Meetting));
ReturnValue = Jsonzs.DataTableToJson(mgdata.Mgdata, '"');
return(ContentJson(ReturnValue));
}
