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