| | |
| | | }; |
| | | return oCn.RunProcReturn("select * from Gy_Czygl where Czymc='" + sUser + "' and Czmm='" + sPsd + "' ", prams, "Gy_Czygl"); |
| | | } |
| | | public DataSet CheckCzymc_AB(string sUser, string sPsd) |
| | | { |
| | | SqlParameter[] prams ={oCn.MakeInParam("@Czymc",SqlDbType.VarChar,100,sUser ), |
| | | oCn.MakeInParam("@Czmm",SqlDbType.VarChar ,100,sPsd ), |
| | | }; |
| | | return oCn.RunProcReturn("select * from Gy_Czygl where Czymc='" + sUser + "' and HICNumber='" + sPsd + "' ", prams, "Gy_Czygl"); |
| | | } |
| | | public DataSet GetUserByMainID(string MainID) |
| | | { |
| | | SqlParameter[] prams={oCn.MakeInParam("@MainID",SqlDbType.VarChar,30,MainID) |