/// <summary> /// 根据groupID得到所有用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static List <Source> GetSourceList() { //List<Source> sourceList = new List<Source>(); //using (DataTable table = SqlHelper.ExecuteDataset(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Source_GetSource").Tables[0]) //{ // foreach (DataRow row in table.Rows) // { // Source u = new Source(); // u.sourceID = int.Parse(row["SourceID"].ToString()); // u.sourceName = row["SourceName"].ToString(); // u.sourceDesc = row["SourceDesc"].ToString(); // sourceList.Add(u); // } //} //return sourceList; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); List <Source> sourceList = new List <Source>(); using (DataTable table = bis.GetSourceTable()) { foreach (DataRow row in table.Rows) { Source u = new Source(); u.sourceID = int.Parse(row["SourceID"].ToString()); u.sourceName = row["SourceName"].ToString(); u.sourceDesc = row["SourceDesc"].ToString(); sourceList.Add(u); } } return(sourceList); }
/// <summary> /// 根据UsageID删除某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool DeleteUsageByUsageID(int UsageID) { //SqlParameter[] Parameters = new SqlParameter[1]; //Parameters[0] = new SqlParameter("@UsageID", SqlDbType.Int); //Parameters[0].Value = UsageID; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Usage_DeleteUsage", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return(bis.DeleteUsageByUsageID(UsageID)); }
/// <summary> /// 更新某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool UpdateSource(Source sc) { //SqlParameter[] Parameters = new SqlParameter[3]; //Parameters[0] = new SqlParameter("@SourceID", SqlDbType.Int); //Parameters[1] = new SqlParameter("@SourceName", SqlDbType.NVarChar); //Parameters[2] = new SqlParameter("@SourceDesc", SqlDbType.NVarChar); //Parameters[0].Value = sc.SourceID; //Parameters[1].Value = sc.SourceName; //Parameters[2].Value = sc.SourceDesc; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Source_UpdateSource", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return(bis.UpdateSource(sc.SourceID, sc.SourceName, sc.SourceDesc)); }
/// <summary> /// 添加某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool AddUsage(Usage us) { //SqlParameter[] Parameters = new SqlParameter[3]; //Parameters[0] = new SqlParameter("@UsageName", SqlDbType.NVarChar); //Parameters[1] = new SqlParameter("@UsageDesc", SqlDbType.NVarChar); //Parameters[2] = new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier); //Parameters[0].Value = us.UsageName; //Parameters[1].Value = us.UsageDesc; //Parameters[2].Value = us.GroupID; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Usage_AddUsage", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return(bis.AddUsage(us.UsageName, us.UsageDesc)); }
/// <summary> /// 根据groupID得到所有用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static List<Source> GetSourceList() { //List<Source> sourceList = new List<Source>(); //using (DataTable table = SqlHelper.ExecuteDataset(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Source_GetSource").Tables[0]) //{ // foreach (DataRow row in table.Rows) // { // Source u = new Source(); // u.sourceID = int.Parse(row["SourceID"].ToString()); // u.sourceName = row["SourceName"].ToString(); // u.sourceDesc = row["SourceDesc"].ToString(); // sourceList.Add(u); // } //} //return sourceList; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); List<Source> sourceList = new List<Source>(); using (DataTable table = bis.GetSourceTable()) { foreach (DataRow row in table.Rows) { Source u = new Source(); u.sourceID = int.Parse(row["SourceID"].ToString()); u.sourceName = row["SourceName"].ToString(); u.sourceDesc = row["SourceDesc"].ToString(); sourceList.Add(u); } } return sourceList; }
/// <summary> /// 添加某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool AddSource(Source sc) { //SqlParameter[] Parameters = new SqlParameter[3]; //Parameters[0] = new SqlParameter("@SourceName", SqlDbType.NVarChar); //Parameters[1] = new SqlParameter("@SourceDesc", SqlDbType.NVarChar); //Parameters[2] = new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier); //Parameters[0].Value = sc.SourceName; //Parameters[1].Value = sc.SourceDesc; //Parameters[2].Value = sc.GroupID; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Source_AddSource", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return bis.AddSource(sc.SourceName, sc.SourceDesc); }
/// <summary> /// 根据SourceID删除某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool DeleteSourceBySourceID(int SourceID) { //SqlParameter[] Parameters = new SqlParameter[1]; //Parameters[0] = new SqlParameter("@SourceID", SqlDbType.Int); //Parameters[0].Value = SourceID; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Source_DeleteSource", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return bis.DeleteSourceBySourceID(SourceID); }
/// <summary> /// 更新某项用途 /// </summary> /// <param name="groupID"></param> /// <returns></returns> public static bool UpdateUsage(Usage us) { //SqlParameter[] Parameters = new SqlParameter[3]; //Parameters[0] = new SqlParameter("@UsageID", SqlDbType.Int); //Parameters[1] = new SqlParameter("@UsageName", SqlDbType.NVarChar); //Parameters[2] = new SqlParameter("@UsageDesc", SqlDbType.NVarChar); //Parameters[0].Value = us.UsageID; //Parameters[1].Value = us.UsageName; //Parameters[2].Value = us.UsageDesc; //int result = SqlHelper.ExecuteNonQuery(SqlHelper.SqlCon_QJVRMS, CommandType.StoredProcedure, "Usage_UpdateUsage", Parameters); //return result == 1; QJVRMS.Business.BaseInfoWS.BaseInfoService bis = new QJVRMS.Business.BaseInfoWS.BaseInfoService(); return bis.UpdateUsage(us.UsageID, us.UsageName, us.UsageDesc); }