public string updatePrjCode(prjCode prjCodeObj, string workNo) { string r = ""; string sql = ""; //if (prjCodeObj.owner != workNo && workNo.ToUpper().Contains("ADMIN")==false) //{ //return "專案代碼管理人才能修改此專案"; //} if (string.IsNullOrEmpty(prjCodeObj.code)) { return("專案代碼不得空白"); } sql = "select count(id) as cnt from prjCodes where code=@code and id != @id"; int icnt = (int)con.ExecuteScalar(sql, new { code = prjCodeObj.code, id = prjCodeObj.id }); if (icnt > 0) { return("專案代碼重複"); } sql = "update prjCodes set code=@code,nm=@nm,owner=@owner,status=@status, "; sql += " mmo1=@mmo1,mmo2=@mmo2,mmo3=@mmo3,mmo4=@mmo4,mmo5=@mmo5,"; sql += " mmo6=@mmo6,mmo7=@mmo7,mmo8=@mmo8,mmo9=@mmo9,mmo10=@mmo10"; sql += " where id=@id"; List <DynamicParameters> paramList = new List <DynamicParameters>(); DynamicParameters param = new DynamicParameters(); param.Add("@id", prjCodeObj.id); param.Add("@code", prjCodeObj.code); param.Add("@nm", prjCodeObj.nm); param.Add("@owner", prjCodeObj.owner); param.Add("@status", prjCodeObj.status); param.Add("@mmo1", prjCodeObj.mmo1); param.Add("@mmo2", prjCodeObj.mmo2); param.Add("@mmo3", prjCodeObj.mmo3); param.Add("@mmo4", prjCodeObj.mmo4); param.Add("@mmo5", prjCodeObj.mmo5); param.Add("@mmo6", prjCodeObj.mmo6); param.Add("@mmo7", prjCodeObj.mmo7); param.Add("@mmo8", prjCodeObj.mmo8); param.Add("@mmo9", prjCodeObj.mmo9); param.Add("@mmo10", prjCodeObj.mmo10); paramList.Add(param); try { con.Execute(sql, paramList); if (string.IsNullOrEmpty(prjCodeObj.creator)) { con.Execute("update prjCodes set creator=@creator,createDate=@createDate where id=@id", new { @id = prjCodeObj.id, @creator = workNo, @createDate = ctx.getLocalTiime() } ); } return(""); } catch (Exception ex) { return(ex.Message); } }
public string createPrjCode(prjCode prjObj, string creator, JArray userList = null) { string r = ""; string sql = ""; if (string.IsNullOrEmpty(prjObj.code)) { return("專案編號不得空白"); } if (string.IsNullOrEmpty(prjObj.nm)) { return("專案名稱不得空白"); } if (string.IsNullOrEmpty(prjObj.owner)) { return("專案經理不得空白"); } sql = "select count(code) as cnt from prjCodes where code=@code"; int icnt = (int)con.ExecuteScalar(sql, new { code = prjObj.code }); if (icnt > 0) { return("專案編號重複"); } sql = "insert into prjCodes "; sql += "(id,code,nm,owner,status,mmo1,mmo2,mmo3,mmo4,mmo5,mmo6,mmo7,mmo8,mmo9,mmo10,creator,createDate) "; sql += " values "; sql += " (@id,@code,@nm,@owner,@status,@mmo1,@mmo2,@mmo3,@mmo4,@mmo5,@mmo6,@mmo7,@mmo8,@mmo9,@mmo10,@creator,@createDate)"; List <DynamicParameters> paramList = new List <DynamicParameters>(); DynamicParameters param = new DynamicParameters(); param.Add("@id", prjObj.id); param.Add("@code", prjObj.code); param.Add("@nm", prjObj.nm); param.Add("@owner", prjObj.owner); param.Add("@status", prjObj.status); param.Add("@mmo1", prjObj.mmo1); param.Add("@mmo2", prjObj.mmo2); param.Add("@mmo3", prjObj.mmo3); param.Add("@mmo4", prjObj.mmo4); param.Add("@mmo5", prjObj.mmo5); param.Add("@mmo6", prjObj.mmo6); param.Add("@mmo7", prjObj.mmo7); param.Add("@mmo8", prjObj.mmo8); param.Add("@mmo9", prjObj.mmo9); param.Add("@mmo10", prjObj.mmo10); param.Add("@creator", creator); param.Add("@createDate", ctx.getLocalTiime()); paramList.Add(param); try { con.Execute(sql, paramList); return(""); } catch (Exception ex) { return(ex.Message); } }