/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_bonding_company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hx_bonding_company(");
strSql.Append("company_name,registered_capital,Date_incorporation,company_address,company_profile,business_licence,business_certificate,contract_covers,contract_bottom,legal_representative,agent,agent_name,agent_id_card,createtime,Tax_NO,GuarType,company_Url,company_tel )");
strSql.Append(" values (");
strSql.Append("@company_name,@registered_capital,@Date_incorporation,@company_address,@company_profile,@business_licence,@business_certificate,@contract_covers,@contract_bottom,@legal_representative,@agent,@agent_name,@agent_id_card,@createtime,@Tax_NO,@GuarType,@company_Url,@company_tel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@company_name", SqlDbType.NVarChar, 100),
new SqlParameter("@registered_capital", SqlDbType.Decimal, 17),
new SqlParameter("@Date_incorporation", SqlDbType.DateTime),
new SqlParameter("@company_address", SqlDbType.VarChar, 100),
new SqlParameter("@company_profile", SqlDbType.VarChar, -1),
new SqlParameter("@business_licence", SqlDbType.VarChar, 50),
new SqlParameter("@business_certificate", SqlDbType.VarChar, 50),
new SqlParameter("@contract_covers", SqlDbType.VarChar, 100),
new SqlParameter("@contract_bottom", SqlDbType.VarChar, 100),
new SqlParameter("@legal_representative", SqlDbType.VarChar, 50),
new SqlParameter("@agent", SqlDbType.VarChar, 50),
new SqlParameter("@agent_name", SqlDbType.VarChar, 50),
new SqlParameter("@agent_id_card", SqlDbType.VarChar, 50),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@Tax_NO", SqlDbType.VarChar, 50),
new SqlParameter("@GuarType", SqlDbType.Int, 4),
new SqlParameter("@company_Url", SqlDbType.VarChar, 350),
new SqlParameter("@company_tel", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.company_name;
parameters[1].Value = model.registered_capital;
parameters[2].Value = model.Date_incorporation;
parameters[3].Value = model.company_address;
parameters[4].Value = model.company_profile;
parameters[5].Value = model.business_licence;
parameters[6].Value = model.business_certificate;
parameters[7].Value = model.contract_covers;
parameters[8].Value = model.contract_bottom;
parameters[9].Value = model.legal_representative;
parameters[10].Value = model.agent;
parameters[11].Value = model.agent_name;
parameters[12].Value = model.agent_id_card;
parameters[13].Value = model.createtime;
parameters[14].Value = model.Tax_NO;
parameters[15].Value = model.GuarType;
parameters[16].Value = model.company_Url;
parameters[17].Value = model.company_tel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_bonding_company GetModel(int companyid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 companyid,company_name,registered_capital,Date_incorporation,company_address,company_profile,business_licence,business_certificate,contract_covers,contract_bottom,legal_representative,agent,agent_name,agent_id_card,createtime,Tax_NO,GuarType,company_Url,company_tel from hx_bonding_company ");
strSql.Append(" where companyid=@companyid");
SqlParameter[] parameters =
{
new SqlParameter("@companyid", SqlDbType.Int, 4)
};
parameters[0].Value = companyid;
M_bonding_company model = new M_bonding_company();
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 bool Update(M_bonding_company model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_bonding_company model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_bonding_company DataRowToModel(DataRow row)
{
M_bonding_company model = new M_bonding_company();
if (row != null)
{
if (row["companyid"] != null && row["companyid"].ToString() != "")
{
model.companyid = int.Parse(row["companyid"].ToString());
}
if (row["company_name"] != null)
{
model.company_name = row["company_name"].ToString();
}
if (row["registered_capital"] != null && row["registered_capital"].ToString() != "")
{
model.registered_capital = decimal.Parse(row["registered_capital"].ToString());
}
if (row["Date_incorporation"] != null && row["Date_incorporation"].ToString() != "")
{
model.Date_incorporation = DateTime.Parse(row["Date_incorporation"].ToString());
}
if (row["company_address"] != null)
{
model.company_address = row["company_address"].ToString();
}
if (row["company_profile"] != null)
{
model.company_profile = row["company_profile"].ToString();
}
if (row["business_licence"] != null)
{
model.business_licence = row["business_licence"].ToString();
}
if (row["business_certificate"] != null)
{
model.business_certificate = row["business_certificate"].ToString();
}
if (row["contract_covers"] != null)
{
model.contract_covers = row["contract_covers"].ToString();
}
if (row["contract_bottom"] != null)
{
model.contract_bottom = row["contract_bottom"].ToString();
}
if (row["legal_representative"] != null)
{
model.legal_representative = row["legal_representative"].ToString();
}
if (row["agent"] != null)
{
model.agent = row["agent"].ToString();
}
if (row["agent_name"] != null)
{
model.agent_name = row["agent_name"].ToString();
}
if (row["agent_id_card"] != null)
{
model.agent_id_card = row["agent_id_card"].ToString();
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["Tax_NO"] != null && row["Tax_NO"].ToString() != "")
{
model.Tax_NO = row["Tax_NO"].ToString();
}
if (row["GuarType"] != null && row["GuarType"].ToString() != "")
{
model.GuarType = int.Parse(row["GuarType"].ToString());
}
if (row["company_Url"] != null)
{
model.company_Url = row["company_Url"].ToString();
}
if (row["company_tel"] != null)
{
model.company_tel = row["company_tel"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(M_bonding_company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hx_bonding_company set ");
strSql.Append("company_name=@company_name,");
strSql.Append("registered_capital=@registered_capital,");
strSql.Append("Date_incorporation=@Date_incorporation,");
strSql.Append("company_address=@company_address,");
strSql.Append("company_profile=@company_profile,");
strSql.Append("business_licence=@business_licence,");
strSql.Append("business_certificate=@business_certificate,");
strSql.Append("contract_covers=@contract_covers,");
strSql.Append("contract_bottom=@contract_bottom,");
strSql.Append("legal_representative=@legal_representative,");
strSql.Append("agent=@agent,");
strSql.Append("agent_name=@agent_name,");
strSql.Append("agent_id_card=@agent_id_card,");
strSql.Append("Tax_NO=@Tax_NO,");
strSql.Append("GuarType=@GuarType,");
strSql.Append("company_Url=@company_Url,");
strSql.Append("company_tel=@company_tel");
strSql.Append(" where companyid=@companyid");
SqlParameter[] parameters =
{
new SqlParameter("@company_name", SqlDbType.NVarChar, 100),
new SqlParameter("@registered_capital", SqlDbType.Decimal, 17),
new SqlParameter("@Date_incorporation", SqlDbType.DateTime),
new SqlParameter("@company_address", SqlDbType.VarChar, 100),
new SqlParameter("@company_profile", SqlDbType.VarChar, -1),
new SqlParameter("@business_licence", SqlDbType.VarChar, 50),
new SqlParameter("@business_certificate", SqlDbType.VarChar, 50),
new SqlParameter("@contract_covers", SqlDbType.VarChar, 100),
new SqlParameter("@contract_bottom", SqlDbType.VarChar, 100),
new SqlParameter("@legal_representative", SqlDbType.VarChar, 50),
new SqlParameter("@agent", SqlDbType.VarChar, 50),
new SqlParameter("@agent_name", SqlDbType.VarChar, 50),
new SqlParameter("@agent_id_card", SqlDbType.VarChar, 50),
new SqlParameter("@Tax_NO", SqlDbType.VarChar, 50),
new SqlParameter("@GuarType", SqlDbType.Int, 4),
new SqlParameter("@company_Url", SqlDbType.VarChar, 500),
new SqlParameter("@company_tel", SqlDbType.VarChar, 50),
new SqlParameter("@companyid", SqlDbType.Int, 4)
};
parameters[0].Value = model.company_name;
parameters[1].Value = model.registered_capital;
parameters[2].Value = model.Date_incorporation;
parameters[3].Value = model.company_address;
parameters[4].Value = model.company_profile;
parameters[5].Value = model.business_licence;
parameters[6].Value = model.business_certificate;
parameters[7].Value = model.contract_covers;
parameters[8].Value = model.contract_bottom;
parameters[9].Value = model.legal_representative;
parameters[10].Value = model.agent;
parameters[11].Value = model.agent_name;
parameters[12].Value = model.agent_id_card;
parameters[13].Value = model.Tax_NO;
parameters[14].Value = model.GuarType;
parameters[15].Value = model.company_Url;
parameters[16].Value = model.company_tel;
parameters[17].Value = model.companyid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
