/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YJUI.Model.renkuan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update renkuan set ");
strSql.Append("BankInfo=@BankInfo,");
strSql.Append("HFee=@HFee,");
strSql.Append("Hmoney=@Hmoney,");
strSql.Append("Customer=@Customer");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@BankInfo", SqlDbType.VarChar, 200),
new SqlParameter("@HFee", SqlDbType.VarChar, 53),
new SqlParameter("@Hmoney", SqlDbType.VarChar, 53),
new SqlParameter("@Customer", SqlDbType.VarChar, 2000),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.BankInfo;
parameters[1].Value = model.HFee;
parameters[2].Value = model.Hmoney;
parameters[3].Value = model.Customer;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YJUI.Model.renkuan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into renkuan(");
strSql.Append("WDate,BankInfo,HFee,Hmoney,Customer)");
strSql.Append(" values (");
strSql.Append("@WDate,@BankInfo,@HFee,@Hmoney,@Customer)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@WDate", SqlDbType.DateTime),
new SqlParameter("@BankInfo", SqlDbType.VarChar, 200),
new SqlParameter("@HFee", SqlDbType.VarChar, 53),
new SqlParameter("@Hmoney", SqlDbType.VarChar, 53),
new SqlParameter("@Customer", SqlDbType.VarChar, 2000)
};
parameters[0].Value = model.WDate;
parameters[1].Value = model.BankInfo;
parameters[2].Value = model.HFee;
parameters[3].Value = model.Hmoney;
parameters[4].Value = model.Customer;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YJUI.Model.renkuan GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,WDate,BankInfo,TMode,HFee,Hmoney,CRemark,Customer,Employee,KRemark,State,QRemark,CustomerID,OrderID,SZJE,RKriqi,crdate,flag from renkuan ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
YJUI.Model.renkuan model = new YJUI.Model.renkuan();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YJUI.Model.renkuan DataRowToModel(DataRow row)
{
YJUI.Model.renkuan model = new YJUI.Model.renkuan();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["WDate"] != null && row["WDate"].ToString() != "")
{
model.WDate = DateTime.Parse(row["WDate"].ToString());
}
if (row["BankInfo"] != null)
{
model.BankInfo = row["BankInfo"].ToString();
}
if (row["TMode"] != null)
{
model.TMode = row["TMode"].ToString();
}
if (row["HFee"] != null)
{
model.HFee = row["HFee"].ToString();
}
if (row["Hmoney"] != null)
{
model.Hmoney = row["Hmoney"].ToString();
}
if (row["CRemark"] != null)
{
model.CRemark = row["CRemark"].ToString();
}
if (row["Customer"] != null)
{
model.Customer = row["Customer"].ToString();
}
if (row["Employee"] != null)
{
model.Employee = row["Employee"].ToString();
}
if (row["KRemark"] != null)
{
model.KRemark = row["KRemark"].ToString();
}
if (row["State"] != null)
{
model.State = row["State"].ToString();
}
if (row["QRemark"] != null)
{
model.QRemark = row["QRemark"].ToString();
}
if (row["CustomerID"] != null)
{
model.CustomerID = row["CustomerID"].ToString();
}
if (row["OrderID"] != null)
{
model.OrderID = row["OrderID"].ToString();
}
if (row["SZJE"] != null)
{
model.SZJE = row["SZJE"].ToString();
}
if (row["RKriqi"] != null)
{
model.RKriqi = row["RKriqi"].ToString();
}
if (row["crdate"] != null && row["crdate"].ToString() != "")
{
model.crdate = DateTime.Parse(row["crdate"].ToString());
}
if (row["flag"] != null)
{
model.flag = row["flag"].ToString();
}
}
return(model);
}
