/// <summary>
/// 增加一条数据
/// </summary>
public void Add(XBase.Model.Decision.CustAnalysis model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into statdba.DataCustAnalysis(");
strSql.Append("CustNo,CustName,CompanyCD,CreateDate,CompanyType,StaffCount,SetupDate,CapitalScale,SaleroomY,SetupMoney,ArrearageCount,ArrearagePrice,BuyCount,BuyPrice,RefundmentCount,RefundmentPrice,ComplainCount,CustGrade,CustProint)");
strSql.Append(" values (");
strSql.Append("@CustNo,@CustName,@CompanyCD,@CreateDate,@CompanyType,@StaffCount,@SetupDate,@CapitalScale,@SaleroomY,@SetupMoney,@ArrearageCount,@ArrearagePrice,@BuyCount,@BuyPrice,@RefundmentCount,@RefundmentPrice,@ComplainCount,@CustGrade,@CustProint)");
SqlParameter[] parameters =
{
new SqlParameter("@CustNo", SqlDbType.NVarChar, 50),
new SqlParameter("@CustName", SqlDbType.NVarChar, 100),
new SqlParameter("@CompanyCD", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@CompanyType", SqlDbType.Int, 4),
new SqlParameter("@StaffCount", SqlDbType.Int, 4),
new SqlParameter("@SetupDate", SqlDbType.Int, 4),
new SqlParameter("@CapitalScale", SqlDbType.Int, 4),
new SqlParameter("@SaleroomY", SqlDbType.Int, 4),
new SqlParameter("@SetupMoney", SqlDbType.Int, 4),
new SqlParameter("@ArrearageCount", SqlDbType.Int, 4),
new SqlParameter("@ArrearagePrice", SqlDbType.Decimal, 13),
new SqlParameter("@BuyCount", SqlDbType.Int, 4),
new SqlParameter("@BuyPrice", SqlDbType.Decimal, 13),
new SqlParameter("@RefundmentCount", SqlDbType.Int, 4),
new SqlParameter("@RefundmentPrice", SqlDbType.Decimal, 13),
new SqlParameter("@ComplainCount", SqlDbType.Int, 4),
new SqlParameter("@CustGrade", SqlDbType.NVarChar, 100),
new SqlParameter("@CustProint", SqlDbType.Int, 4)
};
parameters[0].Value = model.CustNo;
parameters[1].Value = model.CustName;
parameters[2].Value = model.CompanyCD;
parameters[3].Value = model.CreateDate;
parameters[4].Value = model.CompanyType;
parameters[5].Value = model.StaffCount;
parameters[6].Value = model.SetupDate;
parameters[7].Value = model.CapitalScale;
parameters[8].Value = model.SaleroomY;
parameters[9].Value = model.SetupMoney;
parameters[10].Value = model.ArrearageCount;
parameters[11].Value = model.ArrearagePrice;
parameters[12].Value = model.BuyCount;
parameters[13].Value = model.BuyPrice;
parameters[14].Value = model.RefundmentCount;
parameters[15].Value = model.RefundmentPrice;
parameters[16].Value = model.ComplainCount;
parameters[17].Value = model.CustGrade;
parameters[18].Value = model.CustProint;
Database.RunSql(strSql.ToString(), parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <summary>
/// 得到一个对象实体
/// </summary>
public XBase.Model.Decision.CustAnalysis GetModel(int ID)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,CustNo,CustName,CompanyCD,CreateDate,CompanyType,StaffCount,SetupDate,CapitalScale,SaleroomY,SetupMoney,ArrearageCount,ArrearagePrice,BuyCount,BuyPrice,RefundmentCount,RefundmentPrice,ComplainCount,CustGrade,CustProint from statdba.DataCustAnalysis ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
XBase.Model.Decision.CustAnalysis model = new XBase.Model.Decision.CustAnalysis();
DataSet ds = Database.RunSql(strSql.ToString(), parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.CustNo=ds.Tables[0].Rows[0]["CustNo"].ToString();
model.CustName=ds.Tables[0].Rows[0]["CustName"].ToString();
model.CompanyCD=ds.Tables[0].Rows[0]["CompanyCD"].ToString();
if(ds.Tables[0].Rows[0]["CreateDate"].ToString()!="")
{
model.CreateDate=DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if(ds.Tables[0].Rows[0]["CompanyType"].ToString()!="")
{
model.CompanyType=int.Parse(ds.Tables[0].Rows[0]["CompanyType"].ToString());
}
if(ds.Tables[0].Rows[0]["StaffCount"].ToString()!="")
{
model.StaffCount=int.Parse(ds.Tables[0].Rows[0]["StaffCount"].ToString());
}
if(ds.Tables[0].Rows[0]["SetupDate"].ToString()!="")
{
model.SetupDate=int.Parse(ds.Tables[0].Rows[0]["SetupDate"].ToString());
}
if(ds.Tables[0].Rows[0]["CapitalScale"].ToString()!="")
{
model.CapitalScale=int.Parse(ds.Tables[0].Rows[0]["CapitalScale"].ToString());
}
if(ds.Tables[0].Rows[0]["SaleroomY"].ToString()!="")
{
model.SaleroomY=int.Parse(ds.Tables[0].Rows[0]["SaleroomY"].ToString());
}
if(ds.Tables[0].Rows[0]["SetupMoney"].ToString()!="")
{
model.SetupMoney=int.Parse(ds.Tables[0].Rows[0]["SetupMoney"].ToString());
}
if(ds.Tables[0].Rows[0]["ArrearageCount"].ToString()!="")
{
model.ArrearageCount=int.Parse(ds.Tables[0].Rows[0]["ArrearageCount"].ToString());
}
if(ds.Tables[0].Rows[0]["ArrearagePrice"].ToString()!="")
{
model.ArrearagePrice=decimal.Parse(ds.Tables[0].Rows[0]["ArrearagePrice"].ToString());
}
if(ds.Tables[0].Rows[0]["BuyCount"].ToString()!="")
{
model.BuyCount=int.Parse(ds.Tables[0].Rows[0]["BuyCount"].ToString());
}
if(ds.Tables[0].Rows[0]["BuyPrice"].ToString()!="")
{
model.BuyPrice=decimal.Parse(ds.Tables[0].Rows[0]["BuyPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["RefundmentCount"].ToString()!="")
{
model.RefundmentCount=int.Parse(ds.Tables[0].Rows[0]["RefundmentCount"].ToString());
}
if(ds.Tables[0].Rows[0]["RefundmentPrice"].ToString()!="")
{
model.RefundmentPrice=decimal.Parse(ds.Tables[0].Rows[0]["RefundmentPrice"].ToString());
}
if(ds.Tables[0].Rows[0]["ComplainCount"].ToString()!="")
{
model.ComplainCount=int.Parse(ds.Tables[0].Rows[0]["ComplainCount"].ToString());
}
model.CustGrade=ds.Tables[0].Rows[0]["CustGrade"].ToString();
if(ds.Tables[0].Rows[0]["CustProint"].ToString()!="")
{
model.CustProint=int.Parse(ds.Tables[0].Rows[0]["CustProint"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(XBase.Model.Decision.CustAnalysis model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(XBase.Model.Decision.CustAnalysis model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(XBase.Model.Decision.CustAnalysis model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update statdba.DataCustAnalysis set ");
strSql.Append("CustNo=@CustNo,");
strSql.Append("CustName=@CustName,");
strSql.Append("CompanyCD=@CompanyCD,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("CompanyType=@CompanyType,");
strSql.Append("StaffCount=@StaffCount,");
strSql.Append("SetupDate=@SetupDate,");
strSql.Append("CapitalScale=@CapitalScale,");
strSql.Append("SaleroomY=@SaleroomY,");
strSql.Append("SetupMoney=@SetupMoney,");
strSql.Append("ArrearageCount=@ArrearageCount,");
strSql.Append("ArrearagePrice=@ArrearagePrice,");
strSql.Append("BuyCount=@BuyCount,");
strSql.Append("BuyPrice=@BuyPrice,");
strSql.Append("RefundmentCount=@RefundmentCount,");
strSql.Append("RefundmentPrice=@RefundmentPrice,");
strSql.Append("ComplainCount=@ComplainCount,");
strSql.Append("CustGrade=@CustGrade,");
strSql.Append("CustProint=@CustProint");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CustNo", SqlDbType.NVarChar, 50),
new SqlParameter("@CustName", SqlDbType.NVarChar, 100),
new SqlParameter("@CompanyCD", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@CompanyType", SqlDbType.Int, 4),
new SqlParameter("@StaffCount", SqlDbType.Int, 4),
new SqlParameter("@SetupDate", SqlDbType.Int, 4),
new SqlParameter("@CapitalScale", SqlDbType.Int, 4),
new SqlParameter("@SaleroomY", SqlDbType.Int, 4),
new SqlParameter("@SetupMoney", SqlDbType.Int, 4),
new SqlParameter("@ArrearageCount", SqlDbType.Int, 4),
new SqlParameter("@ArrearagePrice", SqlDbType.Decimal, 13),
new SqlParameter("@BuyCount", SqlDbType.Int, 4),
new SqlParameter("@BuyPrice", SqlDbType.Decimal, 13),
new SqlParameter("@RefundmentCount", SqlDbType.Int, 4),
new SqlParameter("@RefundmentPrice", SqlDbType.Decimal, 13),
new SqlParameter("@ComplainCount", SqlDbType.Int, 4),
new SqlParameter("@CustGrade", SqlDbType.NVarChar, 100),
new SqlParameter("@CustProint", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CustNo;
parameters[2].Value = model.CustName;
parameters[3].Value = model.CompanyCD;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.CompanyType;
parameters[6].Value = model.StaffCount;
parameters[7].Value = model.SetupDate;
parameters[8].Value = model.CapitalScale;
parameters[9].Value = model.SaleroomY;
parameters[10].Value = model.SetupMoney;
parameters[11].Value = model.ArrearageCount;
parameters[12].Value = model.ArrearagePrice;
parameters[13].Value = model.BuyCount;
parameters[14].Value = model.BuyPrice;
parameters[15].Value = model.RefundmentCount;
parameters[16].Value = model.RefundmentPrice;
parameters[17].Value = model.ComplainCount;
parameters[18].Value = model.CustGrade;
parameters[19].Value = model.CustProint;
Database.RunSql(strSql.ToString(), parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <summary>
/// 得到一个对象实体
/// </summary>
public XBase.Model.Decision.CustAnalysis GetModel(int ID)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CustNo,CustName,CompanyCD,CreateDate,CompanyType,StaffCount,SetupDate,CapitalScale,SaleroomY,SetupMoney,ArrearageCount,ArrearagePrice,BuyCount,BuyPrice,RefundmentCount,RefundmentPrice,ComplainCount,CustGrade,CustProint from statdba.DataCustAnalysis ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
XBase.Model.Decision.CustAnalysis model = new XBase.Model.Decision.CustAnalysis();
DataSet ds = Database.RunSql(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.CustNo = ds.Tables[0].Rows[0]["CustNo"].ToString();
model.CustName = ds.Tables[0].Rows[0]["CustName"].ToString();
model.CompanyCD = ds.Tables[0].Rows[0]["CompanyCD"].ToString();
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["CompanyType"].ToString() != "")
{
model.CompanyType = int.Parse(ds.Tables[0].Rows[0]["CompanyType"].ToString());
}
if (ds.Tables[0].Rows[0]["StaffCount"].ToString() != "")
{
model.StaffCount = int.Parse(ds.Tables[0].Rows[0]["StaffCount"].ToString());
}
if (ds.Tables[0].Rows[0]["SetupDate"].ToString() != "")
{
model.SetupDate = int.Parse(ds.Tables[0].Rows[0]["SetupDate"].ToString());
}
if (ds.Tables[0].Rows[0]["CapitalScale"].ToString() != "")
{
model.CapitalScale = int.Parse(ds.Tables[0].Rows[0]["CapitalScale"].ToString());
}
if (ds.Tables[0].Rows[0]["SaleroomY"].ToString() != "")
{
model.SaleroomY = int.Parse(ds.Tables[0].Rows[0]["SaleroomY"].ToString());
}
if (ds.Tables[0].Rows[0]["SetupMoney"].ToString() != "")
{
model.SetupMoney = int.Parse(ds.Tables[0].Rows[0]["SetupMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["ArrearageCount"].ToString() != "")
{
model.ArrearageCount = int.Parse(ds.Tables[0].Rows[0]["ArrearageCount"].ToString());
}
if (ds.Tables[0].Rows[0]["ArrearagePrice"].ToString() != "")
{
model.ArrearagePrice = decimal.Parse(ds.Tables[0].Rows[0]["ArrearagePrice"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyCount"].ToString() != "")
{
model.BuyCount = int.Parse(ds.Tables[0].Rows[0]["BuyCount"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyPrice"].ToString() != "")
{
model.BuyPrice = decimal.Parse(ds.Tables[0].Rows[0]["BuyPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["RefundmentCount"].ToString() != "")
{
model.RefundmentCount = int.Parse(ds.Tables[0].Rows[0]["RefundmentCount"].ToString());
}
if (ds.Tables[0].Rows[0]["RefundmentPrice"].ToString() != "")
{
model.RefundmentPrice = decimal.Parse(ds.Tables[0].Rows[0]["RefundmentPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["ComplainCount"].ToString() != "")
{
model.ComplainCount = int.Parse(ds.Tables[0].Rows[0]["ComplainCount"].ToString());
}
model.CustGrade = ds.Tables[0].Rows[0]["CustGrade"].ToString();
if (ds.Tables[0].Rows[0]["CustProint"].ToString() != "")
{
model.CustProint = int.Parse(ds.Tables[0].Rows[0]["CustProint"].ToString());
}
return(model);
}
else
{
return(null);
}
}
