public
int
InsertFileContent(
string
filename,
string
filebrief,
byte
[] content,
string
filetype,
int
sort )
... {
int id = 0;
using (SqlConnection con = new SqlConnection(this.sqlConString))
...{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insFilecontent";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@filename", SqlDbType.NChar, 200);
parm.Value = filename;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filebrief", SqlDbType.NChar, 500);
parm.Value = filebrief;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filecontent", SqlDbType.VarBinary);
parm.Value = content;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filetype", SqlDbType.NChar, 50);
parm.Value = filetype;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filesort", SqlDbType.Int);
parm.Value = filetype;
cmd.Parameters.Add(parm);
SqlParameter parmoutid = new SqlParameter("@id", SqlDbType.Int);//输出值
parmoutid.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parmoutid);
cmd.ExecuteNonQuery();
id = (int)parmoutid.Value;
result = true;
con.Close();
}
return id;
}
... {
int id = 0;
using (SqlConnection con = new SqlConnection(this.sqlConString))
...{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insFilecontent";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@filename", SqlDbType.NChar, 200);
parm.Value = filename;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filebrief", SqlDbType.NChar, 500);
parm.Value = filebrief;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filecontent", SqlDbType.VarBinary);
parm.Value = content;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filetype", SqlDbType.NChar, 50);
parm.Value = filetype;
cmd.Parameters.Add(parm);
parm = new SqlParameter("@filesort", SqlDbType.Int);
parm.Value = filetype;
cmd.Parameters.Add(parm);
SqlParameter parmoutid = new SqlParameter("@id", SqlDbType.Int);//输出值
parmoutid.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parmoutid);
cmd.ExecuteNonQuery();
id = (int)parmoutid.Value;
result = true;
con.Close();
}
return id;
}