86 lines
2.5 KiB
C#
86 lines
2.5 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace Mtxfw.DAL
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:city
|
|
/// </summary>
|
|
public partial class user_zzjf : Mtxfw.Utility.Myabstract
|
|
{
|
|
public user_zzjf()
|
|
: base("user_zzjf")
|
|
{ }
|
|
|
|
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public bool Updatecount(Decimal zznum, Decimal zzjg, Decimal zzjf, int gtype)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update user_zzjf set ");
|
|
strSql.Append("zznum=@zznum,");
|
|
strSql.Append("zzjg=@zzjg,");
|
|
strSql.Append("zzjf=@zzjf");
|
|
strSql.Append(" where gtype=@gtype");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@zznum", SqlDbType.Decimal),
|
|
new SqlParameter("@zzjg", SqlDbType.Decimal),
|
|
new SqlParameter("@zzjf", SqlDbType.Decimal),
|
|
new SqlParameter("@gtype", SqlDbType.Int)};
|
|
parameters[0].Value = zznum;
|
|
parameters[1].Value = zzjg;
|
|
parameters[2].Value = zzjf;
|
|
parameters[3].Value = gtype;
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataSet GetList(string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select * ");
|
|
strSql.Append(" FROM user_zzjf a");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 获得增值价格
|
|
/// </summary>
|
|
public Double GetZZJG(int gtype)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 zzjg");
|
|
strSql.Append(" FROM user_zzjf a where gtype=" + gtype);
|
|
Double ZZJG = 0.00;
|
|
DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
ZZJG = Convert.ToDouble(ds.Tables[0].Rows[0]["zzjg"]);
|
|
}
|
|
ds.Clear();
|
|
return ZZJG;
|
|
}
|
|
|
|
}
|
|
}
|
|
|