public static int AddFilePermit(FilePermit model)
{
int num = 0;
SqlConnection connection = new SqlConnection(SqlHelper.ConnectionString);
connection.Open();
SqlTransaction trans = connection.BeginTransaction();
StringBuilder builder = new StringBuilder();
try
{
builder.Append("insert into OA_File_Permit(");
builder.Append("tpid,tcode,ptype,pcode,pread,pwrite)");
builder.Append(" values (");
builder.Append("@tpid,@tcode,@ptype,@pcode,@pread,@pwrite)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@tpid", SqlDbType.NVarChar, 50), new SqlParameter("@tcode", SqlDbType.NVarChar, 0x200), new SqlParameter("@ptype", SqlDbType.NVarChar, 0x40), new SqlParameter("@pcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@pread", SqlDbType.NVarChar, 0x40), new SqlParameter("@pwrite", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.tpid;
commandParameters[1].Value = model.tcode;
commandParameters[2].Value = model.ptype;
commandParameters[3].Value = model.pcode;
commandParameters[4].Value = model.pread;
commandParameters[5].Value = model.pwrite;
num = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters);
trans.Commit();
}
catch
{
trans.Rollback();
connection.Close();
}
connection.Close();
return(num);
}
public static int UpdateFilePermit(FilePermit model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_File_Permit set ");
builder.Append("tcode=@tcode,");
builder.Append("ptype=@ptype,");
builder.Append("pcode=@pcode");
builder.Append("pread=@pread,");
builder.Append("pwrite=@pwrite");
builder.Append(" where tpid=@tpid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@tpid", SqlDbType.NVarChar, 50), new SqlParameter("@tcode", SqlDbType.NVarChar, 0x200), new SqlParameter("@ptype", SqlDbType.NVarChar, 0x40), new SqlParameter("@pcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@pread", SqlDbType.NVarChar, 0x40), new SqlParameter("@pwrite", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.tpid;
commandParameters[1].Value = model.tcode;
commandParameters[2].Value = model.ptype;
commandParameters[3].Value = model.pcode;
commandParameters[4].Value = model.pread;
commandParameters[5].Value = model.pwrite;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
