/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Chances DataRowToModel(DataRow row)
{
Maticsoft.Model.Chances model = new Maticsoft.Model.Chances();
if (row != null)
{
if (row["ChanID"] != null && row["ChanID"].ToString() != "")
{
model.ChanID = int.Parse(row["ChanID"].ToString());
}
if (row["ChanName"] != null)
{
model.ChanName = row["ChanName"].ToString();
}
if (row["ChanRate"] != null && row["ChanRate"].ToString() != "")
{
model.ChanRate = int.Parse(row["ChanRate"].ToString());
}
if (row["ChanLinkMan"] != null)
{
model.ChanLinkMan = row["ChanLinkMan"].ToString();
}
if (row["ChanLinkTel"] != null)
{
model.ChanLinkTel = row["ChanLinkTel"].ToString();
}
if (row["ChanTitle"] != null)
{
model.ChanTitle = row["ChanTitle"].ToString();
}
if (row["ChanDesc"] != null)
{
model.ChanDesc = row["ChanDesc"].ToString();
}
if (row["ChanCreateMan"] != null && row["ChanCreateMan"].ToString() != "")
{
model.ChanCreateMan = int.Parse(row["ChanCreateMan"].ToString());
}
if (row["ChanCreateDate"] != null && row["ChanCreateDate"].ToString() != "")
{
model.ChanCreateDate = DateTime.Parse(row["ChanCreateDate"].ToString());
}
if (row["ChanDueMan"] != null && row["ChanDueMan"].ToString() != "")
{
model.ChanDueMan = int.Parse(row["ChanDueMan"].ToString());
}
if (row["ChanDueDate"] != null && row["ChanDueDate"].ToString() != "")
{
model.ChanDueDate = DateTime.Parse(row["ChanDueDate"].ToString());
}
if (row["ChanState"] != null && row["ChanState"].ToString() != "")
{
model.ChanState = int.Parse(row["ChanState"].ToString());
}
if (row["ChanError"] != null)
{
model.ChanError = row["ChanError"].ToString();
}
}
return(model);
}
/// <summary>
/// 销售机会状态为成功
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SetChanceSuccess(Maticsoft.Model.Chances model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Chances set ");
strSql.Append("ChanState=@ChanState");
strSql.Append(" where ChanID=@ChanID");
SqlParameter[] parameters =
{
new SqlParameter("@ChanState", SqlDbType.Int, 4),
new SqlParameter("@ChanID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ChanState;
parameters[1].Value = model.ChanID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Chances model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Chances set ");
strSql.Append("ChanName=@ChanName,");
strSql.Append("ChanRate=@ChanRate,");
strSql.Append("ChanLinkMan=@ChanLinkMan,");
strSql.Append("ChanLinkTel=@ChanLinkTel,");
strSql.Append("ChanTitle=@ChanTitle,");
strSql.Append("ChanDesc=@ChanDesc,");
strSql.Append("ChanCreateMan=@ChanCreateMan,");
strSql.Append("ChanDueMan=@ChanDueMan,");
strSql.Append("ChanDueDate=@ChanDueDate,");
strSql.Append("ChanState=@ChanState,");
strSql.Append("ChanError=@ChanError");
strSql.Append(" where ChanID=@ChanID");
SqlParameter[] parameters =
{
new SqlParameter("@ChanName", SqlDbType.NVarChar, 50),
new SqlParameter("@ChanRate", SqlDbType.Int, 4),
new SqlParameter("@ChanLinkMan", SqlDbType.NVarChar, 50),
new SqlParameter("@ChanLinkTel", SqlDbType.VarChar, 50),
new SqlParameter("@ChanTitle", SqlDbType.NVarChar, 500),
new SqlParameter("@ChanDesc", SqlDbType.NVarChar, 2000),
new SqlParameter("@ChanCreateMan", SqlDbType.Int, 4),
new SqlParameter("@ChanDueMan", SqlDbType.Int, 4),
new SqlParameter("@ChanDueDate", SqlDbType.DateTime),
new SqlParameter("@ChanState", SqlDbType.Int, 4),
new SqlParameter("@ChanError", SqlDbType.NVarChar, 500),
new SqlParameter("@ChanID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ChanName;
parameters[1].Value = model.ChanRate;
parameters[2].Value = model.ChanLinkMan;
parameters[3].Value = model.ChanLinkTel;
parameters[4].Value = model.ChanTitle;
parameters[5].Value = model.ChanDesc;
parameters[6].Value = model.ChanCreateMan;
parameters[7].Value = model.ChanDueMan;
parameters[8].Value = model.ChanDueDate;
parameters[9].Value = model.ChanState;
parameters[10].Value = model.ChanError;
parameters[11].Value = model.ChanID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Chances model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Chances(");
strSql.Append("ChanName,ChanRate,ChanLinkMan,ChanLinkTel,ChanTitle,ChanDesc,ChanCreateMan,ChanCreateDate,ChanDueMan,ChanDueDate,ChanState,ChanError)");
strSql.Append(" values (");
strSql.Append("@ChanName,@ChanRate,@ChanLinkMan,@ChanLinkTel,@ChanTitle,@ChanDesc,@ChanCreateMan,@ChanCreateDate,@ChanDueMan,@ChanDueDate,@ChanState,@ChanError)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ChanName", SqlDbType.NVarChar, 50),
new SqlParameter("@ChanRate", SqlDbType.Int, 4),
new SqlParameter("@ChanLinkMan", SqlDbType.NVarChar, 50),
new SqlParameter("@ChanLinkTel", SqlDbType.VarChar, 50),
new SqlParameter("@ChanTitle", SqlDbType.NVarChar, 500),
new SqlParameter("@ChanDesc", SqlDbType.NVarChar, 2000),
new SqlParameter("@ChanCreateMan", SqlDbType.Int, 4),
new SqlParameter("@ChanCreateDate", SqlDbType.DateTime),
new SqlParameter("@ChanDueMan", SqlDbType.Int, 4),
new SqlParameter("@ChanDueDate", SqlDbType.DateTime),
new SqlParameter("@ChanState", SqlDbType.Int, 4),
new SqlParameter("@ChanError", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.ChanName;
parameters[1].Value = model.ChanRate;
parameters[2].Value = model.ChanLinkMan;
parameters[3].Value = model.ChanLinkTel;
parameters[4].Value = model.ChanTitle;
parameters[5].Value = model.ChanDesc;
parameters[6].Value = model.ChanCreateMan;
parameters[7].Value = model.ChanCreateDate;
parameters[8].Value = model.ChanDueMan;
parameters[9].Value = model.ChanDueDate;
parameters[10].Value = model.ChanState;
parameters[11].Value = model.ChanError;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Chances GetModel(int ChanID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ChanID,ChanName,ChanRate,ChanLinkMan,ChanLinkTel,ChanTitle,ChanDesc,ChanCreateMan,ChanCreateDate,ChanDueMan,ChanDueDate,ChanState,ChanError from Chances ");
strSql.Append(" where ChanID=@ChanID");
SqlParameter[] parameters =
{
new SqlParameter("@ChanID", SqlDbType.Int, 4)
};
parameters[0].Value = ChanID;
Maticsoft.Model.Chances model = new Maticsoft.Model.Chances();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
