/// <summary>
/// 得到一个对象实体
/// </summary>
public ERPWPF.Model.Vip DataRowToModel(DataRow row)
{
ERPWPF.Model.Vip model = new ERPWPF.Model.Vip();
if (row != null)
{
if (row["Vid"] != null && row["Vid"].ToString() != "")
{
model.Vid = int.Parse(row["Vid"].ToString());
}
if (row["VName"] != null)
{
model.VName = row["VName"].ToString();
}
if (row["VWeiXin"] != null)
{
model.VWeiXin = row["VWeiXin"].ToString();
}
if (row["VTel"] != null)
{
model.VTel = row["VTel"].ToString();
}
if (row["VIsDaili"] != null)
{
model.VIsDaili = row["VIsDaili"].ToString();
}
if (row["VTimerReg"] != null)
{
model.VTimerReg = row["VTimerReg"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ERPWPF.Model.Vip model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Vip(");
strSql.Append("VName,VWeiXin,VTel,VIsDaili,VTimerReg)");
strSql.Append(" values (");
strSql.Append("@VName,@VWeiXin,@VTel,@VIsDaili,@VTimerReg)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@VName", DbType.String),
new SQLiteParameter("@VWeiXin", DbType.String),
new SQLiteParameter("@VTel", DbType.String),
new SQLiteParameter("@VIsDaili", DbType.String),
new SQLiteParameter("@VTimerReg", DbType.String)
};
parameters[0].Value = model.VName;
parameters[1].Value = model.VWeiXin;
parameters[2].Value = model.VTel;
parameters[3].Value = model.VIsDaili;
parameters[4].Value = model.VTimerReg;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ERPWPF.Model.Vip model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Vip set ");
strSql.Append("VName=@VName,");
strSql.Append("VWeiXin=@VWeiXin,");
strSql.Append("VTel=@VTel,");
strSql.Append("VIsDaili=@VIsDaili,");
strSql.Append("VTimerReg=@VTimerReg");
strSql.Append(" where Vid=@Vid");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@VName", DbType.String),
new SQLiteParameter("@VWeiXin", DbType.String),
new SQLiteParameter("@VTel", DbType.String),
new SQLiteParameter("@VIsDaili", DbType.String),
new SQLiteParameter("@VTimerReg", DbType.String),
new SQLiteParameter("@Vid", DbType.Int32, 8)
};
parameters[0].Value = model.VName;
parameters[1].Value = model.VWeiXin;
parameters[2].Value = model.VTel;
parameters[3].Value = model.VIsDaili;
parameters[4].Value = model.VTimerReg;
parameters[5].Value = model.Vid;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERPWPF.Model.Vip GetModel(int Vid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Vid,VName,VWeiXin,VTel,VIsDaili,VTimerReg from Vip ");
strSql.Append(" where Vid=@Vid");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Vid", DbType.Int32, 4)
};
parameters[0].Value = Vid;
ERPWPF.Model.Vip model = new ERPWPF.Model.Vip();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
