/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Student.Model.ENTERPRISE_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ENTERPRISE_INFO set ");
strSql.Append("ENTNAME=@ENTNAME,");
strSql.Append("ENTADDRESS=@ENTADDRESS,");
strSql.Append("LINKER1=@LINKER1,");
strSql.Append("PHONE1=@PHONE1,");
strSql.Append("LINKER2=@LINKER2,");
strSql.Append("PHONE2=@PHONE2,");
strSql.Append("LINKER3=@LINKER3,");
strSql.Append("PHONE3=@PHONE3,");
strSql.Append("MEMO=@MEMO,");
strSql.Append("DEMAND=@DEMAND");
strSql.Append(" where ENTNO=@ENTNO");
SqlParameter[] parameters =
{
new SqlParameter("@ENTNAME", SqlDbType.VarChar, 200),
new SqlParameter("@ENTADDRESS", SqlDbType.VarChar, 200),
new SqlParameter("@LINKER1", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE1", SqlDbType.VarChar, 20),
new SqlParameter("@LINKER2", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE2", SqlDbType.VarChar, 20),
new SqlParameter("@LINKER3", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE3", SqlDbType.VarChar, 20),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200),
new SqlParameter("@DEMAND", SqlDbType.VarChar, 200),
new SqlParameter("@ENTNO", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.ENTNAME;
parameters[1].Value = model.ENTADDRESS;
parameters[2].Value = model.LINKER1;
parameters[3].Value = model.PHONE1;
parameters[4].Value = model.LINKER2;
parameters[5].Value = model.PHONE2;
parameters[6].Value = model.LINKER3;
parameters[7].Value = model.PHONE3;
parameters[8].Value = model.MEMO;
parameters[9].Value = model.DEMAND;
parameters[10].Value = model.ENTNO;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Student.Model.ENTERPRISE_INFO DataRowToModel(DataRow row)
{
Student.Model.ENTERPRISE_INFO model = new Student.Model.ENTERPRISE_INFO();
if (row != null)
{
if (row["ENTNO"] != null && row["ENTNO"].ToString() != "")
{
model.ENTNO = decimal.Parse(row["ENTNO"].ToString());
}
if (row["ENTNAME"] != null)
{
model.ENTNAME = row["ENTNAME"].ToString();
}
if (row["ENTADDRESS"] != null)
{
model.ENTADDRESS = row["ENTADDRESS"].ToString();
}
if (row["LINKER1"] != null)
{
model.LINKER1 = row["LINKER1"].ToString();
}
if (row["PHONE1"] != null)
{
model.PHONE1 = row["PHONE1"].ToString();
}
if (row["LINKER2"] != null)
{
model.LINKER2 = row["LINKER2"].ToString();
}
if (row["PHONE2"] != null)
{
model.PHONE2 = row["PHONE2"].ToString();
}
if (row["LINKER3"] != null)
{
model.LINKER3 = row["LINKER3"].ToString();
}
if (row["PHONE3"] != null)
{
model.PHONE3 = row["PHONE3"].ToString();
}
if (row["MEMO"] != null)
{
model.MEMO = row["MEMO"].ToString();
}
if (row["DEMAND"] != null)
{
model.DEMAND = row["DEMAND"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Student.Model.ENTERPRISE_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ENTERPRISE_INFO(");
strSql.Append("ENTNAME,ENTADDRESS,LINKER1,PHONE1,LINKER2,PHONE2,LINKER3,PHONE3,MEMO,DEMAND)");
strSql.Append(" values (");
strSql.Append("@ENTNAME,@ENTADDRESS,@LINKER1,@PHONE1,@LINKER2,@PHONE2,@LINKER3,@PHONE3,@MEMO,@DEMAND)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ENTNAME", SqlDbType.VarChar, 200),
new SqlParameter("@ENTADDRESS", SqlDbType.VarChar, 200),
new SqlParameter("@LINKER1", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE1", SqlDbType.VarChar, 20),
new SqlParameter("@LINKER2", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE2", SqlDbType.VarChar, 20),
new SqlParameter("@LINKER3", SqlDbType.VarChar, 20),
new SqlParameter("@PHONE3", SqlDbType.VarChar, 20),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200),
new SqlParameter("@DEMAND", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.ENTNAME;
parameters[1].Value = model.ENTADDRESS;
parameters[2].Value = model.LINKER1;
parameters[3].Value = model.PHONE1;
parameters[4].Value = model.LINKER2;
parameters[5].Value = model.PHONE2;
parameters[6].Value = model.LINKER3;
parameters[7].Value = model.PHONE3;
parameters[8].Value = model.MEMO;
parameters[9].Value = model.DEMAND;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// 根据企业名称查询
/// </summary>
public Student.Model.ENTERPRISE_INFO GetModel(string ENTNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ENTNO,ENTNAME,ENTADDRESS,LINKER1,PHONE1,LINKER2,PHONE2,LINKER3,PHONE3,MEMO,DEMAND from ENTERPRISE_INFO ");
strSql.Append(" where ENTNAME=@ENTNAME");
SqlParameter[] parameters =
{
new SqlParameter("@ENTNAME", SqlDbType.VarChar, 200)
};
parameters[0].Value = ENTNAME;
Student.Model.ENTERPRISE_INFO model = new Student.Model.ENTERPRISE_INFO();
DataSet ds = SqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
