/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.Customers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Customers(");
strSql.Append("CusID,UserID,CusName,CusAddress,CusZip,CusFax,CusWebsite,CusLicenceNo,CusChieftain,CusBankroll,CusTurnover,CusBank,CusBankNo,CusLocalTaxNo,CusNationalTaxNo,CusDate,CusState)");
strSql.Append(" values (");
strSql.Append("@CusID,@UserID,@CusName,@CusAddress,@CusZip,@CusFax,@CusWebsite,@CusLicenceNo,@CusChieftain,@CusBankroll,@CusTurnover,@CusBank,@CusBankNo,@CusLocalTaxNo,@CusNationalTaxNo,@CusDate,@CusState)");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@CusName", SqlDbType.NVarChar, 50),
new SqlParameter("@CusAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@CusZip", SqlDbType.VarChar, 50),
new SqlParameter("@CusFax", SqlDbType.VarChar, 50),
new SqlParameter("@CusWebsite", SqlDbType.VarChar, 100),
new SqlParameter("@CusLicenceNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusChieftain", SqlDbType.NVarChar, 50),
new SqlParameter("@CusBankroll", SqlDbType.Int, 4),
new SqlParameter("@CusTurnover", SqlDbType.Int, 4),
new SqlParameter("@CusBank", SqlDbType.NVarChar, 50),
new SqlParameter("@CusBankNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusLocalTaxNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusNationalTaxNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusDate", SqlDbType.DateTime),
new SqlParameter("@CusState", SqlDbType.Int, 4)
};
parameters[0].Value = model.CusID;
parameters[1].Value = model.UserID;
parameters[2].Value = model.CusName;
parameters[3].Value = model.CusAddress;
parameters[4].Value = model.CusZip;
parameters[5].Value = model.CusFax;
parameters[6].Value = model.CusWebsite;
parameters[7].Value = model.CusLicenceNo;
parameters[8].Value = model.CusChieftain;
parameters[9].Value = model.CusBankroll;
parameters[10].Value = model.CusTurnover;
parameters[11].Value = model.CusBank;
parameters[12].Value = model.CusBankNo;
parameters[13].Value = model.CusLocalTaxNo;
parameters[14].Value = model.CusNationalTaxNo;
parameters[15].Value = model.CusDate;
parameters[16].Value = model.CusState;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Customers GetModel(string CusID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CusID,UserID,CusName,CusAddress,CusZip,CusFax,CusWebsite,CusLicenceNo,CusChieftain,CusBankroll,CusTurnover,CusBank,CusBankNo,CusLocalTaxNo,CusNationalTaxNo,CusDate,CusState from Customers ");
strSql.Append(" where CusID=@CusID ");
SqlParameter[] parameters =
{
new SqlParameter("@CusID", SqlDbType.Char, 14)
};
parameters[0].Value = CusID;
Maticsoft.Model.Customers model = new Maticsoft.Model.Customers();
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 Maticsoft.Model.Customers DataRowToModel(DataRow row)
{
Maticsoft.Model.Customers model = new Maticsoft.Model.Customers();
if (row != null)
{
if (row["CusID"] != null)
{
model.CusID = row["CusID"].ToString();
}
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = int.Parse(row["UserID"].ToString());
}
if (row["CusName"] != null)
{
model.CusName = row["CusName"].ToString();
}
if (row["CusAddress"] != null)
{
model.CusAddress = row["CusAddress"].ToString();
}
if (row["CusZip"] != null)
{
model.CusZip = row["CusZip"].ToString();
}
if (row["CusFax"] != null)
{
model.CusFax = row["CusFax"].ToString();
}
if (row["CusWebsite"] != null)
{
model.CusWebsite = row["CusWebsite"].ToString();
}
if (row["CusLicenceNo"] != null)
{
model.CusLicenceNo = row["CusLicenceNo"].ToString();
}
if (row["CusChieftain"] != null)
{
model.CusChieftain = row["CusChieftain"].ToString();
}
if (row["CusBankroll"] != null && row["CusBankroll"].ToString() != "")
{
model.CusBankroll = int.Parse(row["CusBankroll"].ToString());
}
if (row["CusTurnover"] != null && row["CusTurnover"].ToString() != "")
{
model.CusTurnover = int.Parse(row["CusTurnover"].ToString());
}
if (row["CusBank"] != null)
{
model.CusBank = row["CusBank"].ToString();
}
if (row["CusBankNo"] != null)
{
model.CusBankNo = row["CusBankNo"].ToString();
}
if (row["CusLocalTaxNo"] != null)
{
model.CusLocalTaxNo = row["CusLocalTaxNo"].ToString();
}
if (row["CusNationalTaxNo"] != null)
{
model.CusNationalTaxNo = row["CusNationalTaxNo"].ToString();
}
if (row["CusDate"] != null && row["CusDate"].ToString() != "")
{
model.CusDate = DateTime.Parse(row["CusDate"].ToString());
}
if (row["CusState"] != null && row["CusState"].ToString() != "")
{
model.CusState = int.Parse(row["CusState"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Customers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Customers set ");
strSql.Append("UserID=@UserID,");
strSql.Append("CusName=@CusName,");
strSql.Append("CusAddress=@CusAddress,");
strSql.Append("CusZip=@CusZip,");
strSql.Append("CusFax=@CusFax,");
strSql.Append("CusWebsite=@CusWebsite,");
strSql.Append("CusLicenceNo=@CusLicenceNo,");
strSql.Append("CusChieftain=@CusChieftain,");
strSql.Append("CusBankroll=@CusBankroll,");
strSql.Append("CusTurnover=@CusTurnover,");
strSql.Append("CusBank=@CusBank,");
strSql.Append("CusBankNo=@CusBankNo,");
strSql.Append("CusLocalTaxNo=@CusLocalTaxNo,");
strSql.Append("CusNationalTaxNo=@CusNationalTaxNo,");
strSql.Append("CusDate=@CusDate,");
strSql.Append("CusState=@CusState");
strSql.Append(" where CusID=@CusID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@CusName", SqlDbType.NVarChar, 50),
new SqlParameter("@CusAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@CusZip", SqlDbType.VarChar, 50),
new SqlParameter("@CusFax", SqlDbType.VarChar, 50),
new SqlParameter("@CusWebsite", SqlDbType.VarChar, 100),
new SqlParameter("@CusLicenceNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusChieftain", SqlDbType.NVarChar, 50),
new SqlParameter("@CusBankroll", SqlDbType.Int, 4),
new SqlParameter("@CusTurnover", SqlDbType.Int, 4),
new SqlParameter("@CusBank", SqlDbType.NVarChar, 50),
new SqlParameter("@CusBankNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusLocalTaxNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusNationalTaxNo", SqlDbType.VarChar, 50),
new SqlParameter("@CusDate", SqlDbType.DateTime),
new SqlParameter("@CusState", SqlDbType.Int, 4),
new SqlParameter("@CusID", SqlDbType.Char, 14)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.CusName;
parameters[2].Value = model.CusAddress;
parameters[3].Value = model.CusZip;
parameters[4].Value = model.CusFax;
parameters[5].Value = model.CusWebsite;
parameters[6].Value = model.CusLicenceNo;
parameters[7].Value = model.CusChieftain;
parameters[8].Value = model.CusBankroll;
parameters[9].Value = model.CusTurnover;
parameters[10].Value = model.CusBank;
parameters[11].Value = model.CusBankNo;
parameters[12].Value = model.CusLocalTaxNo;
parameters[13].Value = model.CusNationalTaxNo;
parameters[14].Value = model.CusDate;
parameters[15].Value = model.CusState;
parameters[16].Value = model.CusID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
