📄 vender.cs.svn-base
字号:
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//请先添加引用
namespace Maticsoft.DAL
{
/// <summary>
/// 数据访问类Vender。
/// </summary>
public class Vender
{
public Vender()
{}
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string VenderID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from Vender");
strSql.Append(" where VenderID=@VenderID ");
SqlParameter[] parameters = {
new SqlParameter("@VenderID", SqlDbType.NVarChar,50)};
parameters[0].Value = VenderID;
return DbHelperSQL.Exists(strSql.ToString(),parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Maticsoft.Model.Vender model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Vender(");
strSql.Append("VenderID,VenderName,SpellCode,LinkMan,LinkPhone,Fax,Address,AccountBank,AccountNo,VenderType,PayMoney,TotalMoney,LogInName,PassWord,IsActive)");
strSql.Append(" values (");
strSql.Append("@VenderID,@VenderName,@SpellCode,@LinkMan,@LinkPhone,@Fax,@Address,@AccountBank,@AccountNo,@VenderType,@PayMoney,@TotalMoney,@LogInName,@PassWord,@IsActive)");
SqlParameter[] parameters = {
new SqlParameter("@VenderID", SqlDbType.NVarChar,12),
new SqlParameter("@VenderName", SqlDbType.NVarChar,100),
new SqlParameter("@SpellCode", SqlDbType.NVarChar,50),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,20),
new SqlParameter("@LinkPhone", SqlDbType.NVarChar,20),
new SqlParameter("@Fax", SqlDbType.NVarChar,20),
new SqlParameter("@Address", SqlDbType.NVarChar,50),
new SqlParameter("@AccountBank", SqlDbType.NVarChar,50),
new SqlParameter("@AccountNo", SqlDbType.NVarChar,20),
new SqlParameter("@VenderType", SqlDbType.NVarChar,20),
new SqlParameter("@PayMoney", SqlDbType.Decimal,9),
new SqlParameter("@TotalMoney", SqlDbType.Decimal,9),
new SqlParameter("@LogInName", SqlDbType.NVarChar,30),
new SqlParameter("@PassWord", SqlDbType.NVarChar,30),
new SqlParameter("@IsActive", SqlDbType.Bit,1)};
parameters[0].Value = model.VenderID;
parameters[1].Value = model.VenderName;
parameters[2].Value = model.SpellCode;
parameters[3].Value = model.LinkMan;
parameters[4].Value = model.LinkPhone;
parameters[5].Value = model.Fax;
parameters[6].Value = model.Address;
parameters[7].Value = model.AccountBank;
parameters[8].Value = model.AccountNo;
parameters[9].Value = model.VenderType;
parameters[10].Value = model.PayMoney;
parameters[11].Value = model.TotalMoney;
parameters[12].Value = model.LogInName;
parameters[13].Value = model.PassWord;
parameters[14].Value = model.IsActive;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.Vender model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Vender set ");
strSql.Append("VenderName=@VenderName,");
strSql.Append("SpellCode=@SpellCode,");
strSql.Append("LinkMan=@LinkMan,");
strSql.Append("LinkPhone=@LinkPhone,");
strSql.Append("Fax=@Fax,");
strSql.Append("Address=@Address,");
strSql.Append("AccountBank=@AccountBank,");
strSql.Append("AccountNo=@AccountNo,");
strSql.Append("VenderType=@VenderType,");
strSql.Append("PayMoney=@PayMoney,");
strSql.Append("TotalMoney=@TotalMoney,");
strSql.Append("LogInName=@LogInName,");
strSql.Append("PassWord=@PassWord,");
strSql.Append("IsActive=@IsActive");
strSql.Append(" where VenderID=@VenderID ");
SqlParameter[] parameters = {
new SqlParameter("@VenderID", SqlDbType.NVarChar,12),
new SqlParameter("@VenderName", SqlDbType.NVarChar,100),
new SqlParameter("@SpellCode", SqlDbType.NVarChar,50),
new SqlParameter("@LinkMan", SqlDbType.NVarChar,20),
new SqlParameter("@LinkPhone", SqlDbType.NVarChar,20),
new SqlParameter("@Fax", SqlDbType.NVarChar,20),
new SqlParameter("@Address", SqlDbType.NVarChar,50),
new SqlParameter("@AccountBank", SqlDbType.NVarChar,50),
new SqlParameter("@AccountNo", SqlDbType.NVarChar,20),
new SqlParameter("@VenderType", SqlDbType.NVarChar,20),
new SqlParameter("@PayMoney", SqlDbType.Decimal,9),
new SqlParameter("@TotalMoney", SqlDbType.Decimal,9),
new SqlParameter("@LogInName", SqlDbType.NVarChar,30),
new SqlParameter("@PassWord", SqlDbType.NVarChar,30),
new SqlParameter("@IsActive", SqlDbType.Bit,1)};
parameters[0].Value = model.VenderID;
parameters[1].Value = model.VenderName;
parameters[2].Value = model.SpellCode;
parameters[3].Value = model.LinkMan;
parameters[4].Value = model.LinkPhone;
parameters[5].Value = model.Fax;
parameters[6].Value = model.Address;
parameters[7].Value = model.AccountBank;
parameters[8].Value = model.AccountNo;
parameters[9].Value = model.VenderType;
parameters[10].Value = model.PayMoney;
parameters[11].Value = model.TotalMoney;
parameters[12].Value = model.LogInName;
parameters[13].Value = model.PassWord;
parameters[14].Value = model.IsActive;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(string VenderID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete Vender ");
strSql.Append(" where VenderID=@VenderID ");
SqlParameter[] parameters = {
new SqlParameter("@VenderID", SqlDbType.NVarChar,50)};
parameters[0].Value = VenderID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Vender GetModel(string VenderID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select VenderID,VenderName,SpellCode,LinkMan,LinkPhone,Fax,Address,AccountBank,AccountNo,VenderType,PayMoney,TotalMoney,LogInName,PassWord,IsActive from Vender ");
strSql.Append(" where VenderID=@VenderID ");
SqlParameter[] parameters = {
new SqlParameter("@VenderID", SqlDbType.NVarChar,50)};
parameters[0].Value = VenderID;
Maticsoft.Model.Vender model=new Maticsoft.Model.Vender();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
model.VenderID=ds.Tables[0].Rows[0]["VenderID"].ToString();
model.VenderName=ds.Tables[0].Rows[0]["VenderName"].ToString();
model.SpellCode=ds.Tables[0].Rows[0]["SpellCode"].ToString();
model.LinkMan=ds.Tables[0].Rows[0]["LinkMan"].ToString();
model.LinkPhone=ds.Tables[0].Rows[0]["LinkPhone"].ToString();
model.Fax=ds.Tables[0].Rows[0]["Fax"].ToString();
model.Address=ds.Tables[0].Rows[0]["Address"].ToString();
model.AccountBank=ds.Tables[0].Rows[0]["AccountBank"].ToString();
model.AccountNo=ds.Tables[0].Rows[0]["AccountNo"].ToString();
model.VenderType=ds.Tables[0].Rows[0]["VenderType"].ToString();
if(ds.Tables[0].Rows[0]["PayMoney"].ToString()!="")
{
model.PayMoney=decimal.Parse(ds.Tables[0].Rows[0]["PayMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["TotalMoney"].ToString()!="")
{
model.TotalMoney=decimal.Parse(ds.Tables[0].Rows[0]["TotalMoney"].ToString());
}
model.LogInName=ds.Tables[0].Rows[0]["LogInName"].ToString();
model.PassWord=ds.Tables[0].Rows[0]["PassWord"].ToString();
if(ds.Tables[0].Rows[0]["IsActive"].ToString()!="")
{
if((ds.Tables[0].Rows[0]["IsActive"].ToString()=="1")||(ds.Tables[0].Rows[0]["IsActive"].ToString().ToLower()=="true"))
{
model.IsActive=true;
}
else
{
model.IsActive=false;
}
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select VenderID,VenderName,SpellCode,LinkMan,LinkPhone,Fax,Address,AccountBank,AccountNo,VenderType,PayMoney,TotalMoney,LogInName,PassWord,IsActive ");
strSql.Append(" FROM Vender ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "Vender";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion 成员方法
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -