public int Add()
{
int newid = 0;
try
{
newid = Convert.ToInt32(DBUtil.DBOp("ConnDB", " exec dbo.usp_CaseUser_xAddCaseUserComment {0},{1},{2},{3},{4},{5}",
new string[] { CaseID.ToString(), CreatedUserID.ToString(), RemarkType, RemarkContent, FileID.ToString(), (RemarkType == "3" ? "1":"0") }
, NSDBUtil.CmdOpType.ExecuteScalar));
}
catch {
}
return(newid);
}
public bool HaveColumn(string columnName, string columnValue, out bool retValueMatched)
{
bool ret = false;
bool valueMatched = false;
if (columnName == "InfoPageID")
{
ret = true;
if (InfoPageID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "InfoPageGUID")
{
ret = true;
if (InfoPageGUID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "RevisionNo")
{
ret = true;
if (RevisionNo.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "UserID")
{
ret = true;
if (UserID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "UserGUID")
{
ret = true;
if (UserGUID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CreatedDate")
{
ret = true;
if (CreatedDate.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "LastUpdateDate")
{
ret = true;
if (LastUpdateDate.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CreatedUserID")
{
ret = true;
if (CreatedUserID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CreatedUserGUID")
{
ret = true;
if (CreatedUserGUID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "InfoPageName")
{
ret = true;
if (InfoPageName.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "InfoPageDescription")
{
ret = true;
if (InfoPageDescription.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "InfoCategoryID")
{
ret = true;
if (InfoCategoryID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "InfoCategoryGUID")
{
ret = true;
if (InfoCategoryGUID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "AccessGroupID")
{
ret = true;
if (AccessGroupID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "AccessGroupGUID")
{
ret = true;
if (AccessGroupGUID.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "AsyncLoading")
{
ret = true;
if (AsyncLoading.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "Commentable")
{
ret = true;
if (Commentable.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CommentorRoleList")
{
ret = true;
if (CommentorRoleList.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CommentorGroupList")
{
ret = true;
if (CommentorGroupList.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CommentorHideRoleList")
{
ret = true;
if (CommentorHideRoleList.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "CommentorHideGroupList")
{
ret = true;
if (CommentorHideGroupList.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "IsActive")
{
ret = true;
if (IsActive.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "ExpiryDate")
{
ret = true;
if (ExpiryDate.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "IsCommon")
{
ret = true;
if (IsCommon.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "IsPublic")
{
ret = true;
if (IsPublic.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "Sequence")
{
ret = true;
if (Sequence.ToString() == columnValue)
{
valueMatched = true;
}
}
if (columnName == "IsDeleted")
{
ret = true;
if (IsDeleted.ToString() == columnValue)
{
valueMatched = true;
}
}
retValueMatched = valueMatched;
return(ret);
}
