/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(viviapi.Model.Sys.debuginfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@bugtype", SqlDbType.TinyInt, 1),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@url", SqlDbType.VarChar, 2000),
new SqlParameter("@errorcode", SqlDbType.VarChar, 50),
new SqlParameter("@errorinfo", SqlDbType.VarChar, 200),
new SqlParameter("@detail", SqlDbType.VarChar, 500),
new SqlParameter("@addtime", SqlDbType.DateTime),
new SqlParameter("@userorder", SqlDbType.VarChar, 30)
};
parameters[0].Value = model.id;
parameters[1].Value = (int)model.bugtype;
parameters[2].Value = model.userid;
parameters[3].Value = model.url;
parameters[4].Value = model.errorcode;
parameters[5].Value = model.errorinfo;
parameters[6].Value = model.detail;
parameters[7].Value = model.addtime;
parameters[8].Value = model.userorder;
object result = DataBase.ExecuteScalar(CommandType.StoredProcedure, "proc_debuginfo_Insert", parameters);
if (result != null)
{
return(Convert.ToInt32(result));
}
return(0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Insert(viviapi.Model.Sys.debuginfo model)
{
try
{
return(dal.Insert(model));
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
