private static SqlCommand GetCmdPublish(string ReportID, ReportPublicPosition location)
{
SqlCommand cmd = new SqlCommand(
//string.Format("UPDATE UAP_Report SET bPublished=1 WHERE ID=N'{0}'", ReportID));
string.Format("UPDATE UAP_Report SET bPublished={0} WHERE ID=N'{1}'", Convert.ToInt32(location), ReportID));
cmd.CommandType = CommandType.Text;//modify by yanghx
return(cmd);
}
public static bool Publish(string ReportID, string cAccId, string cYear, string userId, ReportPublicPosition location)
{
CheckCnnString();
AddRptAndViewAuth(_DbCnnString, ReportID, cAccId, cYear, userId);
SqlHelper.ExecuteNonQuery(_DbCnnString, GetCmdPublish(ReportID, ReportPublicPosition.CS));//总是只设置Cs为了事务一直行
return(true);
}
