SP 返回字串用法

通常固定的字元會維護在Web.Config 中.但是因為PM 提出修改線上的Source 及Web.Config 需要很煩的簽核,但是修改隨意DB.為了方便以後維護,把很多固定值都通過SP 返回.如下建立SP

CREATE PROCEDURE [dbo].[USP_GetFabTransferDocIDList]
as
BEGIN
 SET NOCOUNT ON;
 SELECT '176,181,182' AS doc_idlist
END
asp.net cs 後台應用:
                DbCommand dc = db.GetStoredProcCommand("USP_GetFabTransferDocIDList");
                string strReturn = (string)db.ExecuteScalar(dc);   //取得Doc ID List 如：'176,181,182' 配置在SP 中
                string[] docList = strReturn.Split(',');
                for (int i = 0; i < docList.Length; i++)
                {
                    DbCommand dcList = db.GetStoredProcCommand("USP_CreateFabTransferDocList");
                    db.AddInParameter(dcList, "@PN_ID", DbType.Int32, partNumber.ID);
                    db.AddInParameter(dcList, "@DOC_ID", DbType.Int32, int.Parse(docList[i].Trim().ToString()));
                    db.AddInParameter(dcList, "@CREATE_USER", DbType.Guid, userID);
                    db.AddInParameter(dcList, "@ACTIVE", DbType.Boolean, true);
                    db.ExecuteNonQuery(dcList);
                }