/// <summary>
/// 删
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public bool DeleteSysattachments(SysattachmentsModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from Sysattachments where 1=1 ");
sb.Append("and AID=@AID ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@AID", model.AID));
int res = Base.MySQLHelper.MySQLNonQuery(sb.ToString(), pms);
return(res > 0);
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public SysattachmentsModel GetSysattachmentsInfo(SysattachmentsModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from Sysattachments where 1=1 ");
sb.Append("and AID=@AID ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@AID", model.AID));
DataTable dt = Base.MySQLHelper.MySQLQueryTab(sb.ToString(), pms);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
return(new SysattachmentsModel(dt.Rows[0]));
}
/// <summary>
/// 改
/// </summary>
/// <param name="model">model to be updated</param>
/// <returns></returns>
public bool UpdateSysattachments(SysattachmentsModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("update Sysattachments set ");
sb.Append("AName=@AName, AType=@AType, APath=@APath, ACreateTime=@ACreateTime,ProjectID=@ProjectID,ObjectID=@ObjectID ");
sb.Append("where 1=1 ");
sb.Append("and AID=@AID ");
List <MySqlParameter> pms = new List <MySqlParameter>();
pms.Add(new MySqlParameter("@AID", model.AID));
pms.Add(new MySqlParameter("@AName", model.AName));
pms.Add(new MySqlParameter("@AType", model.AType));
pms.Add(new MySqlParameter("@APath", model.APath));
pms.Add(new MySqlParameter("@ACreateTime", model.ACreateTime));
pms.Add(new MySqlParameter("@ProjectID", model.ProjectID));
pms.Add(new MySqlParameter("@ObjectID", model.ObjectID));
int res = Base.MySQLHelper.MySQLNonQuery(sb.ToString(), pms);
return(res > 0);
}
/// <summary>
/// 增
/// </summary>
/// <param name="model">new model</param>
/// <returns></returns>
public bool AddSysattachments(SysattachmentsModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into Sysattachments ( ");
sb.Append("AName,AType,APath,ACreateTime,ProjectID,ObjectID");
sb.Append(") values ( ");
sb.Append("@AName,@AType,@APath,@ACreateTime,@ProjectID,@ObjectID");
sb.Append(") ");
List <MySqlParameter> pms = new List <MySqlParameter>();
//pms.Add(new MySqlParameter("@AID", model.AID));
pms.Add(new MySqlParameter("@AName", model.AName));
pms.Add(new MySqlParameter("@AType", model.AType));
pms.Add(new MySqlParameter("@APath", model.APath));
pms.Add(new MySqlParameter("@ACreateTime", model.ACreateTime));
pms.Add(new MySqlParameter("@ProjectID", model.ProjectID));
pms.Add(new MySqlParameter("@ObjectID", model.ObjectID));
int res = Base.MySQLHelper.MySQLNonQuery(sb.ToString(), pms);
return(res > 0);
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public static SysattachmentsModel GetSysattachmentsInfo(SysattachmentsModel model)
{
return(Common.Instance._Sysattachments.GetSysattachmentsInfo(model));
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool DeleteSysattachments(SysattachmentsModel model)
{
return(Common.Instance._Sysattachments.DeleteSysattachments(model));
}
