/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fkdw model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fkdw(");
strSql.Append("SKDW_MC,ZTIDH,ID,XJ,VIP)");
strSql.Append(" values (");
strSql.Append("@SKDW_MC,@ZTIDH,@ID,@XJ,@VIP)");
MySqlParameter[] parameters =
{
new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18),
new MySqlParameter("@ID", MySqlDbType.Decimal, 18),
new MySqlParameter("@XJ", MySqlDbType.VarChar, 30),
new MySqlParameter("@VIP", MySqlDbType.VarChar, 30)
};
parameters[0].Value = model.SKDW_MC;
parameters[1].Value = model.ZTIDH;
parameters[2].Value = model.ID;
parameters[3].Value = model.XJ;
parameters[4].Value = model.VIP;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fkdw DataRowToModel(DataRow row)
{
FMS_Model.fkdw model = new FMS_Model.fkdw();
if (row != null)
{
if (row["SKDW_MC"] != null)
{
model.SKDW_MC = row["SKDW_MC"].ToString();
}
if (row["ZTIDH"] != null && row["ZTIDH"].ToString() != "")
{
model.ZTIDH = decimal.Parse(row["ZTIDH"].ToString());
}
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["XJ"] != null)
{
model.XJ = row["XJ"].ToString();
}
if (row["VIP"] != null)
{
model.VIP = row["VIP"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fkdw GetModel(string SKDW_MC, decimal ZTIDH, decimal ID, string XJ, string VIP)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SKDW_MC,ZTIDH,ID,XJ,VIP from fkdw ");
strSql.Append(" where SKDW_MC=@SKDW_MC and ZTIDH=@ZTIDH and ID=@ID and XJ=@XJ and VIP=@VIP ");
MySqlParameter[] parameters =
{
new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18),
new MySqlParameter("@ID", MySqlDbType.Decimal, 18),
new MySqlParameter("@XJ", MySqlDbType.VarChar, 30),
new MySqlParameter("@VIP", MySqlDbType.VarChar, 30)
};
parameters[0].Value = SKDW_MC;
parameters[1].Value = ZTIDH;
parameters[2].Value = ID;
parameters[3].Value = XJ;
parameters[4].Value = VIP;
FMS_Model.fkdw model = new FMS_Model.fkdw();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fkdw model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fkdw set ");
strSql.Append("SKDW_MC=@SKDW_MC,");
strSql.Append("ZTIDH=@ZTIDH,");
strSql.Append("ID=@ID,");
strSql.Append("XJ=@XJ,");
strSql.Append("VIP=@VIP");
strSql.Append(" where SKDW_MC=@SKDW_MC and ZTIDH=@ZTIDH and ID=@ID and XJ=@XJ and VIP=@VIP ");
MySqlParameter[] parameters =
{
new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18),
new MySqlParameter("@ID", MySqlDbType.Decimal, 18),
new MySqlParameter("@XJ", MySqlDbType.VarChar, 30),
new MySqlParameter("@VIP", MySqlDbType.VarChar, 30)
};
parameters[0].Value = model.SKDW_MC;
parameters[1].Value = model.ZTIDH;
parameters[2].Value = model.ID;
parameters[3].Value = model.XJ;
parameters[4].Value = model.VIP;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fkdw model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.fkdw model)
{
return(dal.Add(model));
}
