/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.s2XinFuZhu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into s2XinFuZhu(");
strSql.Append("sBianMa,bXinFuZhu,sZhuYuanHao,sFangAn,sJiLiang,sLiaoCheng,sLiaoXiaoPingJia,sFangLiaoFangAn,sFangLiaoLiaoCheng,bShuQian2thBingJian,sResult,bXinFuZhuFangLiao,iUserID)");
strSql.Append(" values (");
strSql.Append("@sBianMa,@bXinFuZhu,@sZhuYuanHao,@sFangAn,@sJiLiang,@sLiaoCheng,@sLiaoXiaoPingJia,@sFangLiaoFangAn,@sFangLiaoLiaoCheng,@bShuQian2thBingJian,@sResult,@bXinFuZhuFangLiao,@iUserID)");
OleDbParameter[] parameters =
{
new OleDbParameter("@sBianMa", OleDbType.VarChar, 255),
new OleDbParameter("@bXinFuZhu", OleDbType.Boolean, 1),
new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255),
new OleDbParameter("@sFangAn", OleDbType.VarChar, 255),
new OleDbParameter("@sJiLiang", OleDbType.VarChar, 255),
new OleDbParameter("@sLiaoCheng", OleDbType.VarChar, 255),
new OleDbParameter("@sLiaoXiaoPingJia", OleDbType.VarChar, 255),
new OleDbParameter("@sFangLiaoFangAn", OleDbType.VarChar, 255),
new OleDbParameter("@sFangLiaoLiaoCheng", OleDbType.VarChar, 255),
new OleDbParameter("@bShuQian2thBingJian", OleDbType.Boolean, 1),
new OleDbParameter("@sResult", OleDbType.VarChar, 255),
new OleDbParameter("@bXinFuZhuFangLiao", OleDbType.Boolean, 1),
new OleDbParameter("@iUserID", OleDbType.Integer, 4)
};
parameters[0].Value = model.sBianMa;
parameters[1].Value = model.bXinFuZhu;
parameters[2].Value = model.sZhuYuanHao;
parameters[3].Value = model.sFangAn;
parameters[4].Value = model.sJiLiang;
parameters[5].Value = model.sLiaoCheng;
parameters[6].Value = model.sLiaoXiaoPingJia;
parameters[7].Value = model.sFangLiaoFangAn;
parameters[8].Value = model.sFangLiaoLiaoCheng;
parameters[9].Value = model.bShuQian2thBingJian;
parameters[10].Value = model.sResult;
parameters[11].Value = model.bXinFuZhuFangLiao;
parameters[12].Value = model.iUserID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.s2XinFuZhu GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,sBianMa,bXinFuZhu,sZhuYuanHao,sFangAn,sJiLiang,sLiaoCheng,sLiaoXiaoPingJia,sFangLiaoFangAn,sFangLiaoLiaoCheng,bShuQian2thBingJian,sResult,bXinFuZhuFangLiao,iUserID from s2XinFuZhu ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.s2XinFuZhu model = new Maticsoft.Model.s2XinFuZhu();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.s2XinFuZhu DataRowToModel(DataRow row)
{
Maticsoft.Model.s2XinFuZhu model = new Maticsoft.Model.s2XinFuZhu();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["sBianMa"] != null)
{
model.sBianMa = row["sBianMa"].ToString();
}
if (row["bXinFuZhu"] != null && row["bXinFuZhu"].ToString() != "")
{
if ((row["bXinFuZhu"].ToString() == "1") || (row["bXinFuZhu"].ToString().ToLower() == "true"))
{
model.bXinFuZhu = true;
}
else
{
model.bXinFuZhu = false;
}
}
if (row["sZhuYuanHao"] != null)
{
model.sZhuYuanHao = row["sZhuYuanHao"].ToString();
}
if (row["sFangAn"] != null)
{
model.sFangAn = row["sFangAn"].ToString();
}
if (row["sJiLiang"] != null)
{
model.sJiLiang = row["sJiLiang"].ToString();
}
if (row["sLiaoCheng"] != null)
{
model.sLiaoCheng = row["sLiaoCheng"].ToString();
}
if (row["sLiaoXiaoPingJia"] != null)
{
model.sLiaoXiaoPingJia = row["sLiaoXiaoPingJia"].ToString();
}
if (row["sFangLiaoFangAn"] != null)
{
model.sFangLiaoFangAn = row["sFangLiaoFangAn"].ToString();
}
if (row["sFangLiaoLiaoCheng"] != null)
{
model.sFangLiaoLiaoCheng = row["sFangLiaoLiaoCheng"].ToString();
}
if (row["bShuQian2thBingJian"] != null && row["bShuQian2thBingJian"].ToString() != "")
{
if ((row["bShuQian2thBingJian"].ToString() == "1") || (row["bShuQian2thBingJian"].ToString().ToLower() == "true"))
{
model.bShuQian2thBingJian = true;
}
else
{
model.bShuQian2thBingJian = false;
}
}
if (row["sResult"] != null)
{
model.sResult = row["sResult"].ToString();
}
if (row["bXinFuZhuFangLiao"] != null && row["bXinFuZhuFangLiao"].ToString() != "")
{
if ((row["bXinFuZhuFangLiao"].ToString() == "1") || (row["bXinFuZhuFangLiao"].ToString().ToLower() == "true"))
{
model.bXinFuZhuFangLiao = true;
}
else
{
model.bXinFuZhuFangLiao = false;
}
}
if (row["iUserID"] != null && row["iUserID"].ToString() != "")
{
model.iUserID = int.Parse(row["iUserID"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.s2XinFuZhu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update s2XinFuZhu set ");
strSql.Append("sBianMa=@sBianMa,");
strSql.Append("bXinFuZhu=@bXinFuZhu,");
strSql.Append("sZhuYuanHao=@sZhuYuanHao,");
strSql.Append("sFangAn=@sFangAn,");
strSql.Append("sJiLiang=@sJiLiang,");
strSql.Append("sLiaoCheng=@sLiaoCheng,");
strSql.Append("sLiaoXiaoPingJia=@sLiaoXiaoPingJia,");
strSql.Append("sFangLiaoFangAn=@sFangLiaoFangAn,");
strSql.Append("sFangLiaoLiaoCheng=@sFangLiaoLiaoCheng,");
strSql.Append("bShuQian2thBingJian=@bShuQian2thBingJian,");
strSql.Append("sResult=@sResult,");
strSql.Append("bXinFuZhuFangLiao=@bXinFuZhuFangLiao,");
strSql.Append("iUserID=@iUserID");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@sBianMa", OleDbType.VarChar, 255),
new OleDbParameter("@bXinFuZhu", OleDbType.Boolean, 1),
new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255),
new OleDbParameter("@sFangAn", OleDbType.VarChar, 255),
new OleDbParameter("@sJiLiang", OleDbType.VarChar, 255),
new OleDbParameter("@sLiaoCheng", OleDbType.VarChar, 255),
new OleDbParameter("@sLiaoXiaoPingJia", OleDbType.VarChar, 255),
new OleDbParameter("@sFangLiaoFangAn", OleDbType.VarChar, 255),
new OleDbParameter("@sFangLiaoLiaoCheng", OleDbType.VarChar, 255),
new OleDbParameter("@bShuQian2thBingJian", OleDbType.Boolean, 1),
new OleDbParameter("@sResult", OleDbType.VarChar, 255),
new OleDbParameter("@bXinFuZhuFangLiao", OleDbType.Boolean, 1),
new OleDbParameter("@iUserID", OleDbType.Integer, 4),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.sBianMa;
parameters[1].Value = model.bXinFuZhu;
parameters[2].Value = model.sZhuYuanHao;
parameters[3].Value = model.sFangAn;
parameters[4].Value = model.sJiLiang;
parameters[5].Value = model.sLiaoCheng;
parameters[6].Value = model.sLiaoXiaoPingJia;
parameters[7].Value = model.sFangLiaoFangAn;
parameters[8].Value = model.sFangLiaoLiaoCheng;
parameters[9].Value = model.bShuQian2thBingJian;
parameters[10].Value = model.sResult;
parameters[11].Value = model.bXinFuZhuFangLiao;
parameters[12].Value = model.iUserID;
parameters[13].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
