/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(ParameterName entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Sys_ParameterName set [ConfigName]=@ConfigName,[No]=@No,[Memo]=@Memo where [Id]=@Id ");
dr.AddParameters("ConfigName", DbType.String, 50, entity.ConfigName);
dr.AddParameters("No", DbType.Int32, entity.No);
dr.AddParameters("Memo", DbType.String, 250, entity.Memo);
dr.AddParameters("Id", DbType.Int32, entity.Id);
int value = dr.ExecuteNonQuery();
dr.Close();
return(value);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(ParameterValue entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Sys_ParameterValue set [Value]=@Value,[No]=@No,[Memo]=@Memo where [Id]=@Id");
dr.AddParameters("Value", DbType.String, 60, entity.Value);
dr.AddParameters("No", DbType.Int32, entity.No);
dr.AddParameters("Memo", DbType.String, 300, entity.Memo);
dr.AddParameters("Id", DbType.Int32, entity.Id);
object value = dr.ExecuteNonQuery();
dr.Close();
return(Convert.ToInt32(value));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(System_User entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Sys_User set [LoginName]=@LoginName,[Pwd]=@Pwd,[UserName]=@UserName,[Remarks]=@Remarks where [Id]=@Id ");
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);
dr.AddParameters("Id", DbType.Int32, entity.Id);
int value = dr.ExecuteNonQuery();
dr.Close();
return(value);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(Expend entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Expend set [ExpendDate]=@ExpendDate,[Year_Date]=@Year_Date,[Month_Date]=@Month_Date,[Day_Date]=@Day_Date,[ExpendType]=@ExpendType,[ItemName]=@ItemName,[Amount]=@Amount,[Reason]=@Reason,[Remarks]=@Remarks where [Id]=@Id ");
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);
dr.AddParameters("Id", DbType.Int32, entity.Id);
return(dr.ExecuteNonQuery());
}