/**/
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.EntryLog model)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EntryLog(");
strSql.Append("Name,LandingDate)");
strSql.Append(" values (");
strSql.Append("@Name,@LandingDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = ...{
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@LandingDate", SqlDbType.DateTime)};
parameters[0].Value = model.Name;
parameters[1].Value = model.LandingDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
...{
return 1;
}
else
...{
return Convert.ToInt32(obj);
}
}
/**/ /// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.EntryLog model)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("update EntryLog set ");
strSql.Append("Name=@Name,");
strSql.Append("LandingDate=@LandingDate");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = ...{
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@LandingDate", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
parameters[2].Value = model.LandingDate;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/**/ /// <summary>
/// 删除一条数据
/// </summary>
public void Delete( int ID)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("delete EntryLog ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = ...{
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.EntryLog model)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into EntryLog(");
strSql.Append("Name,LandingDate)");
strSql.Append(" values (");
strSql.Append("@Name,@LandingDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = ...{
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@LandingDate", SqlDbType.DateTime)};
parameters[0].Value = model.Name;
parameters[1].Value = model.LandingDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
...{
return 1;
}
else
...{
return Convert.ToInt32(obj);
}
}
/**/ /// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.EntryLog model)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("update EntryLog set ");
strSql.Append("Name=@Name,");
strSql.Append("LandingDate=@LandingDate");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = ...{
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@LandingDate", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
parameters[2].Value = model.LandingDate;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/**/ /// <summary>
/// 删除一条数据
/// </summary>
public void Delete( int ID)
... {
StringBuilder strSql=new StringBuilder();
strSql.Append("delete EntryLog ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = ...{
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}