/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(ParameterValue entity)
{
try
{
entity.Status = "1";
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("insert into Sys_ParameterValue([P_Id],[Value],[No],[Memo])values(@P_Id,@Value,@No,@Memo);select @@identity");
dr.AddParameters("P_Id", DbType.Int32, entity.P_Id);
dr.AddParameters("Value", DbType.String, 60, entity.Value);
dr.AddParameters("No", DbType.Int32, entity.No);
dr.AddParameters("Memo", DbType.String, 300, entity.Memo);
int value = Convert.ToInt32(dr.ExecuteScalar());
entity.Id = value;
dr.Close();
return(0);
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
return(-1);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(System_User entity)
{
try
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("insert into Sys_User([LoginName],[Pwd],[UserName],[Remarks])values(@LoginName,@Pwd,@UserName,@Remarks);select @@identity");
dr.AddParameters("LoginName", DbType.String, 30, entity.LoginName);
dr.AddParameters("Pwd", DbType.String, 20, entity.Pwd);
dr.AddParameters("UserName", DbType.String, 8, entity.UserName);
dr.AddParameters("Remarks", DbType.String, 200, entity.Remarks);
int value = Convert.ToInt32(dr.ExecuteScalar());
entity.Id = value;
dr.Close();
return(0);
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
return(-1);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(Expend entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
int value = -1;
try
{
dr.InitiCommand("insert into Expend([ExpendDate],[Year_Date],[Month_Date],[Day_Date],[ExpendType],[ItemName],[Amount],[Reason],[Remarks])values(@ExpendDate,@Year_Date,@Month_Date,@Day_Date,@ExpendType,@ItemName,@Amount,@Reason,@Remarks);SELECT @@IDENTITY;");
dr.AddParameters("ExpendDate", DbType.DateTime, entity.ExpendDate);
dr.AddParameters("Year_Date", DbType.String, 20, entity.Year_Date);
dr.AddParameters("Month_Date", DbType.String, 20, entity.Month_Date);
dr.AddParameters("Day_Date", DbType.Int32, entity.Day_Date);
dr.AddParameters("ExpendType", DbType.String, 50, entity.ExpendType);
dr.AddParameters("ItemName", DbType.String, 72, entity.ItemName);
dr.AddParameters("Amount", DbType.Decimal, entity.Amount);
dr.AddParameters("Reason", DbType.String, 250, entity.Reason);
dr.AddParameters("Remarks", DbType.String, 500, entity.Remarks);
object id = dr.ExecuteScalar();
entity.Id = Convert.ToInt32(id);
value = 1;
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
value = -1;
}
return(value);
}
