/// <summary>
///
/// </summary>
/// <param name="rowStatus"></param>
/// <param name="tblName"></param>
/// <param name="columnName"></param>
/// <param name="columnLabelName"></param>
/// <param name="columnValue"></param>
/// <param name="pkeysConds">"and sysProductClassId !='" + actRow.sysProductClassId.ToString() + "'"</param>
/// <returns></returns>
public static string Chk_ColumnValue(string rowStatus, string tblName, string columnName, string columnLabelName, string columnValue, string pkeysConds)
{
int count;
if (rowStatus == "A")
{
count = Convert.ToInt32(SqlTool.GetOneDataValue("select count(*) from " + tblName + " where statusx='10' and " + columnName + "='" + columnValue + "'"));
if (count > 0)
{
return(string.Format("啟用中之{0}:【{1}】,<br>不可重複 ", columnLabelName, columnValue));
}
}
else
{
count = Convert.ToInt32(SqlTool.GetOneDataValue("select count(*) from " + tblName + " where statusx='10' and " + columnName + "='" + columnValue + "' " + pkeysConds));
if (count > 0)
{
return(string.Format("啟用中之{0}:【{1}】,<br>不可重複 ", columnLabelName, columnValue));
}
}
return("");
}
public ActionResult DeleteSingle(string pks)
{
try
{
ZhWebClassV3.UserData userData = ZhWebClassV3.UserHelper.GetUserData();
string[] pk = pks.Split('/');
object pk_sysObjectId = pk[0];
//查詢是否有使用者隸屬於該群組下
strSql.Remove(0, strSql.Length);
int count = Convert.ToInt32(SqlTool.GetOneDataValue("SELECT COUNT(*) FROM Q10_userVsObject WHERE sysObjectId='" + pk_sysObjectId + "'"));
if (count == 0)
{
#region 刪除 Server端的資料
strSql.Remove(0, strSql.Length);
strSql.Append("update Q10_Objects set statusx='30' where sysObjectId=@pk_sysObjectId");
SqlParameter[] param =
{
new SqlParameter("pk_sysObjectId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pk_sysObjectId)
};
errStr = SqlTool.ExecuteNonQuery(strSql.ToString(), param);
if (errStr != "")
{
throw new Exception(errStr);
}
#region OperLog 刪除群組
if (Convert.ToBoolean(ZhConfig.GlobalSystemVar.tbl_OperLogFlag.Rows.Find(funcId)["isOperLogEnable"]) && errStr == "")
{
#region Gen tbl_operLog1 Data (Add/Modify)
DataTable tbl_operLog1 = userData.Get_tbl_operLogPart1();
tbl_operLog1.Columns.Add("sysObjectId", typeof(string));
DataRow operLogRow = tbl_operLog1.NewRow();
//operLogRow["rowId"] =0;
operLogRow["actSerial"] = userData.actSerial;
operLogRow["sysUserId"] = userData.sysUserId;
operLogRow["actStatus"] = "D";
operLogRow["sysObjectId"] = pk_sysObjectId;
tbl_operLog1.Rows.Add(operLogRow);
#endregion
errStr = ZhWebClassSet.Log.LogSet.SaveOperLog(funcId, "S10_userGroup", tbl_operLog1);
if (errStr != "")
{
throw new Exception(errStr);
}
}
#endregion
}
else
{
errStr = "Can't Delete";
}
#endregion
if (errStr == "")
{
return(Json("OK", JsonRequestBehavior.DenyGet));
}
else if (errStr == "Can't Delete")
{
return(Json("Can't Delete", JsonRequestBehavior.DenyGet));
}
else
{
return(Json(errStr, JsonRequestBehavior.DenyGet));
}
#endregion
}
catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.DenyGet)); }
}