/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_agent_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_agent_info(");
strSql.Append("managerId,companyName,companyInfo,agentPrice,agentPrice2,sqJine,czTotMoney,remainMony,userNum,wcodeNum,agentType,agentLevel,industry,agentArea,expiryDate,aRemark,createDate)");
strSql.Append(" values (");
strSql.Append("@managerId,@companyName,@companyInfo,@agentPrice,@agentPrice2,@sqJine,@czTotMoney,@remainMony,@userNum,@wcodeNum,@agentType,@agentLevel,@industry,@agentArea,@expiryDate,@aRemark,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@managerId", SqlDbType.Int, 4),
new SqlParameter("@companyName", SqlDbType.VarChar, 200),
new SqlParameter("@companyInfo", SqlDbType.VarChar, 800),
new SqlParameter("@agentPrice", SqlDbType.Int, 4),
new SqlParameter("@agentPrice2", SqlDbType.Int, 4),
new SqlParameter("@sqJine", SqlDbType.Int, 4),
new SqlParameter("@czTotMoney", SqlDbType.Int, 4),
new SqlParameter("@remainMony", SqlDbType.Int, 4),
new SqlParameter("@userNum", SqlDbType.Int, 4),
new SqlParameter("@wcodeNum", SqlDbType.Int, 4),
new SqlParameter("@agentType", SqlDbType.Int, 4),
new SqlParameter("@agentLevel", SqlDbType.VarChar, 50),
new SqlParameter("@industry", SqlDbType.VarChar, 200),
new SqlParameter("@agentArea", SqlDbType.VarChar, 300),
new SqlParameter("@expiryDate", SqlDbType.DateTime),
new SqlParameter("@aRemark", SqlDbType.VarChar, 1500),
new SqlParameter("@createDate", SqlDbType.DateTime)
};
parameters[0].Value = model.managerId;
parameters[1].Value = model.companyName;
parameters[2].Value = model.companyInfo;
parameters[3].Value = model.agentPrice;
parameters[4].Value = model.agentPrice2;
parameters[5].Value = model.sqJine;
parameters[6].Value = model.czTotMoney;
parameters[7].Value = model.remainMony;
parameters[8].Value = model.userNum;
parameters[9].Value = model.wcodeNum;
parameters[10].Value = model.agentType;
parameters[11].Value = model.agentLevel;
parameters[12].Value = model.industry;
parameters[13].Value = model.agentArea;
parameters[14].Value = model.expiryDate;
parameters[15].Value = model.aRemark;
parameters[16].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_agent_info GetAgentModel(int managerId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,managerId,companyName,companyInfo,agentPrice,agentPrice2,sqJine,czTotMoney,remainMony,userNum,wcodeNum,agentType,agentLevel,industry,agentArea,expiryDate,aRemark,createDate from wx_agent_info ");
strSql.Append(" where managerId=@managerId");
SqlParameter[] parameters =
{
new SqlParameter("@managerId", SqlDbType.Int, 4)
};
parameters[0].Value = managerId;
MxWeiXinPF.Model.wx_agent_info model = new MxWeiXinPF.Model.wx_agent_info();
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 MxWeiXinPF.Model.wx_agent_info DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_agent_info model = new MxWeiXinPF.Model.wx_agent_info();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["managerId"] != null && row["managerId"].ToString() != "")
{
model.managerId = int.Parse(row["managerId"].ToString());
}
if (row["companyName"] != null)
{
model.companyName = row["companyName"].ToString();
}
if (row["companyInfo"] != null)
{
model.companyInfo = row["companyInfo"].ToString();
}
if (row["agentPrice"] != null && row["agentPrice"].ToString() != "")
{
model.agentPrice = int.Parse(row["agentPrice"].ToString());
}
if (row["agentPrice2"] != null && row["agentPrice2"].ToString() != "")
{
model.agentPrice2 = int.Parse(row["agentPrice2"].ToString());
}
if (row["sqJine"] != null && row["sqJine"].ToString() != "")
{
model.sqJine = int.Parse(row["sqJine"].ToString());
}
if (row["czTotMoney"] != null && row["czTotMoney"].ToString() != "")
{
model.czTotMoney = int.Parse(row["czTotMoney"].ToString());
}
if (row["remainMony"] != null && row["remainMony"].ToString() != "")
{
model.remainMony = int.Parse(row["remainMony"].ToString());
}
if (row["userNum"] != null && row["userNum"].ToString() != "")
{
model.userNum = int.Parse(row["userNum"].ToString());
}
if (row["wcodeNum"] != null && row["wcodeNum"].ToString() != "")
{
model.wcodeNum = int.Parse(row["wcodeNum"].ToString());
}
if (row["agentType"] != null && row["agentType"].ToString() != "")
{
model.agentType = int.Parse(row["agentType"].ToString());
}
if (row["agentLevel"] != null)
{
model.agentLevel = row["agentLevel"].ToString();
}
if (row["industry"] != null)
{
model.industry = row["industry"].ToString();
}
if (row["agentArea"] != null)
{
model.agentArea = row["agentArea"].ToString();
}
if (row["expiryDate"] != null && row["expiryDate"].ToString() != "")
{
model.expiryDate = DateTime.Parse(row["expiryDate"].ToString());
}
if (row["aRemark"] != null)
{
model.aRemark = row["aRemark"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MxWeiXinPF.Model.wx_agent_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_agent_info set ");
strSql.Append("managerId=@managerId,");
strSql.Append("companyName=@companyName,");
strSql.Append("companyInfo=@companyInfo,");
strSql.Append("agentPrice=@agentPrice,");
strSql.Append("agentPrice2=@agentPrice2,");
strSql.Append("sqJine=@sqJine,");
strSql.Append("czTotMoney=@czTotMoney,");
strSql.Append("remainMony=@remainMony,");
strSql.Append("userNum=@userNum,");
strSql.Append("wcodeNum=@wcodeNum,");
strSql.Append("agentType=@agentType,");
strSql.Append("agentLevel=@agentLevel,");
strSql.Append("industry=@industry,");
strSql.Append("agentArea=@agentArea,");
strSql.Append("expiryDate=@expiryDate,");
strSql.Append("aRemark=@aRemark,");
strSql.Append("createDate=@createDate");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@managerId", SqlDbType.Int, 4),
new SqlParameter("@companyName", SqlDbType.VarChar, 200),
new SqlParameter("@companyInfo", SqlDbType.VarChar, 800),
new SqlParameter("@agentPrice", SqlDbType.Int, 4),
new SqlParameter("@agentPrice2", SqlDbType.Int, 4),
new SqlParameter("@sqJine", SqlDbType.Int, 4),
new SqlParameter("@czTotMoney", SqlDbType.Int, 4),
new SqlParameter("@remainMony", SqlDbType.Int, 4),
new SqlParameter("@userNum", SqlDbType.Int, 4),
new SqlParameter("@wcodeNum", SqlDbType.Int, 4),
new SqlParameter("@agentType", SqlDbType.Int, 4),
new SqlParameter("@agentLevel", SqlDbType.VarChar, 50),
new SqlParameter("@industry", SqlDbType.VarChar, 200),
new SqlParameter("@agentArea", SqlDbType.VarChar, 300),
new SqlParameter("@expiryDate", SqlDbType.DateTime),
new SqlParameter("@aRemark", SqlDbType.VarChar, 1500),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.managerId;
parameters[1].Value = model.companyName;
parameters[2].Value = model.companyInfo;
parameters[3].Value = model.agentPrice;
parameters[4].Value = model.agentPrice2;
parameters[5].Value = model.sqJine;
parameters[6].Value = model.czTotMoney;
parameters[7].Value = model.remainMony;
parameters[8].Value = model.userNum;
parameters[9].Value = model.wcodeNum;
parameters[10].Value = model.agentType;
parameters[11].Value = model.agentLevel;
parameters[12].Value = model.industry;
parameters[13].Value = model.agentArea;
parameters[14].Value = model.expiryDate;
parameters[15].Value = model.aRemark;
parameters[16].Value = model.createDate;
parameters[17].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
