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)); }