public bool update_table(clsFitment cf)
{
try
{
con.ConDatabase();
SqlCommand cmd = new SqlCommand("proc_fitment_update", con.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
SqlParameter[] prams =
{
new SqlParameter("@house_fitmentID", SqlDbType.VarChar, 50),
new SqlParameter("@fitment_name", SqlDbType.VarChar, 50),
new SqlParameter("@fitment_remark", SqlDbType.VarChar, 50)
};
prams[0].Value = cf.id;
prams[1].Value = cf.name;
prams[2].Value = cf.remark;
// 添加参数
foreach (SqlParameter parameter in prams)
{
cmd.Parameters.Add(parameter);
}
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch
{
con.closeCon();
return(false);
}
}
public string insert_table(clsFitment cf)
{
try
{
con.ConDatabase();
SqlCommand cmd = new SqlCommand("proc_fitment_insert", con.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("@house_fitmentID", SqlDbType.VarChar, 50).Value = cf.id;
cmd.Parameters.Add("@fitment_name", SqlDbType.VarChar, 50).Value = cf.name;
cmd.Parameters.Add("@fitment_remark", SqlDbType.VarChar, 50).Value = cf.remark;
SqlParameter sp = new SqlParameter();
sp.ParameterName = "@proc_info";
sp.Direction = ParameterDirection.Output;
sp.Size = 20;
cmd.Parameters.Add(sp);
cmd.ExecuteNonQuery();
string strResult = cmd.Parameters["@proc_info"].Value.ToString();
con.closeCon();
return(strResult);
}
catch (Exception ey)
{
con.closeCon();
return(ey.Message.ToString());
}
#region
//try
//{
// con.ConDatabase();
// SqlCommand cmd = new SqlCommand("proc_fitment_insert", con.conn);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Connection.Open();
// SqlParameter[] prams =
// {
// new SqlParameter("@house_fitmentID", SqlDbType.VarChar, 50),
// new SqlParameter("@fitment_name", SqlDbType.VarChar, 50),
// new SqlParameter("@fitment_remark", SqlDbType.VarChar, 50),
// new SqlParameter("@proc_info", SqlDbType.VarChar, 50, ParameterDirection.Output,true, 0, 0, string.Empty,DataRowVersion.Default, null)
// };
// prams[0].Value = cf.id;
// prams[1].Value = cf.name;
// prams[2].Value = cf.remark;
// // 添加参数
// foreach (SqlParameter parameter in prams)
// {
// cmd.Parameters.Add(parameter);
// }
// cmd.ExecuteNonQuery();
// string strResult = cmd.Parameters["@proc_info"].Value.ToString();
// con.closeCon();
// return strResult;
//}
//catch (Exception ey)
//{
// con.closeCon();
// return ey.Message.ToString();
//}
#endregion
}