/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_suppliers GetModel(int suppliers_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from ecs_suppliers ");
strSql.Append(" where suppliers_id=@suppliers_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@suppliers_id", MySqlDbType.Int32)
};
parameters[0].Value = suppliers_id;
XHD.Model.ecs_suppliers model = new XHD.Model.ecs_suppliers();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.Model.ecs_suppliers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ecs_suppliers(");
strSql.Append("scm_factoryId,suppliers_code,suppliers_erp_code,suppliers_name,suppliers_desc,suppliers_tel,dealer_id,is_check,add_time,add_empId,add_empName,update_time,update_empId,update_empName,type_grade,Provinces_id,Provinces,City_id,City,District_id,District,factory_UserNum,wms_suppliers_id,sync_outKingdee)");
strSql.Append(" values (");
strSql.Append("@scm_factoryId,@suppliers_code,@suppliers_erp_code,@suppliers_name,@suppliers_desc,@suppliers_tel,@dealer_id,@is_check,@add_time,@add_empId,@add_empName,@update_time,@update_empId,@update_empName,@type_grade,@Provinces_id,@Provinces,@City_id,@City,@District_id,@District,@factory_UserNum,@wms_suppliers_id,@sync_outKingdee)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@scm_factoryId", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_code", MySqlDbType.VarChar, 60),
new MySqlParameter("@suppliers_erp_code", MySqlDbType.VarChar, 30),
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@suppliers_desc", MySqlDbType.String),
new MySqlParameter("@suppliers_tel", MySqlDbType.VarChar, 30),
new MySqlParameter("@dealer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@is_check", MySqlDbType.Int32, 1),
new MySqlParameter("@add_time", MySqlDbType.VarChar, 32),
new MySqlParameter("@add_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@add_empName", MySqlDbType.VarChar, 60),
new MySqlParameter("@update_time", MySqlDbType.VarChar, 32),
new MySqlParameter("@update_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@update_empName", MySqlDbType.VarChar, 60),
new MySqlParameter("@type_grade", MySqlDbType.VarChar, 1),
new MySqlParameter("@Provinces_id", MySqlDbType.Int32, 11),
new MySqlParameter("@Provinces", MySqlDbType.VarChar, 100),
new MySqlParameter("@City_id", MySqlDbType.Int32, 11),
new MySqlParameter("@City", MySqlDbType.VarChar, 100),
new MySqlParameter("@District_id", MySqlDbType.Int32, 11),
new MySqlParameter("@District", MySqlDbType.VarChar, 100),
new MySqlParameter("@factory_UserNum", MySqlDbType.Int32, 11),
new MySqlParameter("@wms_suppliers_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@sync_outKingdee", MySqlDbType.Int32, 2)
};
parameters[0].Value = model.scm_factoryId;
parameters[1].Value = model.suppliers_code;
parameters[2].Value = model.suppliers_erp_code;
parameters[3].Value = model.suppliers_name;
parameters[4].Value = model.suppliers_desc;
parameters[5].Value = model.suppliers_tel;
parameters[6].Value = model.dealer_id;
parameters[7].Value = model.is_check;
parameters[8].Value = model.add_time;
parameters[9].Value = model.add_empId;
parameters[10].Value = model.add_empName;
parameters[11].Value = model.update_time;
parameters[12].Value = model.update_empId;
parameters[13].Value = model.update_empName;
parameters[14].Value = model.type_grade;
parameters[15].Value = model.Provinces_id;
parameters[16].Value = model.Provinces;
parameters[17].Value = model.City_id;
parameters[18].Value = model.City;
parameters[19].Value = model.District_id;
parameters[20].Value = model.District;
parameters[21].Value = model.factory_UserNum;
parameters[22].Value = model.wms_suppliers_id;
parameters[23].Value = model.sync_outKingdee;
object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.ecs_suppliers DataRowToModel(DataRow row)
{
XHD.Model.ecs_suppliers model = new XHD.Model.ecs_suppliers();
if (row != null)
{
if (row["suppliers_id"] != null && row["suppliers_id"].ToString() != "")
{
model.suppliers_id = int.Parse(row["suppliers_id"].ToString());
}
if (row["scm_factoryId"] != null)
{
model.scm_factoryId = row["scm_factoryId"].ToString();
}
if (row["suppliers_code"] != null)
{
model.suppliers_code = row["suppliers_code"].ToString();
}
if (row["suppliers_erp_code"] != null)
{
model.suppliers_erp_code = row["suppliers_erp_code"].ToString();
}
if (row["suppliers_name"] != null)
{
model.suppliers_name = row["suppliers_name"].ToString();
}
//model.suppliers_desc=row["suppliers_desc"].ToString();
if (row["suppliers_tel"] != null)
{
model.suppliers_tel = row["suppliers_tel"].ToString();
}
if (row["dealer_id"] != null && row["dealer_id"].ToString() != "")
{
model.dealer_id = int.Parse(row["dealer_id"].ToString());
}
if (row["is_check"] != null && row["is_check"].ToString() != "")
{
model.is_check = int.Parse(row["is_check"].ToString());
}
if (row["add_time"] != null)
{
model.add_time = row["add_time"].ToString();
}
if (row["add_empId"] != null && row["add_empId"].ToString() != "")
{
model.add_empId = int.Parse(row["add_empId"].ToString());
}
if (row["add_empName"] != null)
{
model.add_empName = row["add_empName"].ToString();
}
if (row["update_time"] != null)
{
model.update_time = row["update_time"].ToString();
}
if (row["update_empId"] != null && row["update_empId"].ToString() != "")
{
model.update_empId = int.Parse(row["update_empId"].ToString());
}
if (row["update_empName"] != null)
{
model.update_empName = row["update_empName"].ToString();
}
if (row["type_grade"] != null)
{
model.type_grade = row["type_grade"].ToString();
}
if (row["Provinces_id"] != null && row["Provinces_id"].ToString() != "")
{
model.Provinces_id = int.Parse(row["Provinces_id"].ToString());
}
if (row["Provinces"] != null)
{
model.Provinces = row["Provinces"].ToString();
}
if (row["City_id"] != null && row["City_id"].ToString() != "")
{
model.City_id = int.Parse(row["City_id"].ToString());
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["District_id"] != null && row["District_id"].ToString() != "")
{
model.District_id = int.Parse(row["District_id"].ToString());
}
if (row["District"] != null)
{
model.District = row["District"].ToString();
}
if (row["factory_UserNum"] != null && row["factory_UserNum"].ToString() != "")
{
model.factory_UserNum = int.Parse(row["factory_UserNum"].ToString());
}
if (row["period_start"] != null && row["period_start"].ToString() != "")
{
model.period_start = decimal.Parse(row["period_start"].ToString());
}
if (row["period_start_date"] != null && row["period_start_date"].ToString() != "")
{
model.period_start_date = Convert.ToDateTime(row["factory_UserNum"].ToString());
}
if (row["is_stop"] != null && row["is_stop"].ToString() != "")
{
model.Is_stop = int.Parse(row["is_stop"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.ecs_suppliers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ecs_suppliers set ");
strSql.Append("suppliers_name=@suppliers_name,");
strSql.Append("suppliers_tel=@suppliers_tel,");
strSql.Append("is_enable=@is_enable,");
strSql.Append("factory_UserNum=@factory_UserNum,");
strSql.Append("Provinces_id=@Provinces_id,");
strSql.Append("Provinces=@Provinces,");
strSql.Append("City_id=@City_id,");
strSql.Append("City=@City,");
strSql.Append("District_id=@District_id,");
strSql.Append("District=@District,");
strSql.Append("suppliers_desc=@suppliers_desc,");
strSql.Append("update_empId=@update_empId,");
strSql.Append("update_empName=@update_empName,");
strSql.Append("update_time=@update_time,");
strSql.Append("suppliers_erp_code=@suppliers_erp_code,");
strSql.Append("wms_suppliers_id=@wms_suppliers_id,");
strSql.Append("sync_outKingdee=@sync_outKingdee");
strSql.Append(" where suppliers_id=@suppliers_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@suppliers_tel", MySqlDbType.VarChar, 30),
new MySqlParameter("@factory_UserNum", MySqlDbType.Int32, 11),
new MySqlParameter("@is_enable", MySqlDbType.Int32, 1),
new MySqlParameter("@Provinces_id", MySqlDbType.Int32, 11),
new MySqlParameter("@Provinces", MySqlDbType.VarChar, 100),
new MySqlParameter("@City_id", MySqlDbType.Int32, 11),
new MySqlParameter("@City", MySqlDbType.VarChar, 100),
new MySqlParameter("@District_id", MySqlDbType.Int32, 11),
new MySqlParameter("@District", MySqlDbType.VarChar, 100),
new MySqlParameter("@suppliers_desc", MySqlDbType.String),
new MySqlParameter("@update_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@update_empName", MySqlDbType.VarChar, 60),
new MySqlParameter("@update_time", MySqlDbType.VarChar, 32),
new MySqlParameter("@suppliers_erp_code", MySqlDbType.VarChar, 30),
new MySqlParameter("@wms_suppliers_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@sync_outKingdee", MySqlDbType.Int32, 2),
new MySqlParameter("@suppliers_id", MySqlDbType.Int32, 5)
};
parameters[0].Value = model.suppliers_name;
parameters[1].Value = model.suppliers_tel;
parameters[2].Value = model.factory_UserNum;
parameters[3].Value = model.is_enable;
parameters[4].Value = model.Provinces_id;
parameters[5].Value = model.Provinces;
parameters[6].Value = model.City_id;
parameters[7].Value = model.City;
parameters[8].Value = model.District_id;
parameters[9].Value = model.District;
parameters[10].Value = model.suppliers_desc;
parameters[11].Value = model.update_empId;
parameters[12].Value = model.update_empName;
parameters[13].Value = model.update_time;
parameters[14].Value = model.suppliers_erp_code;
parameters[15].Value = model.wms_suppliers_id;
parameters[16].Value = model.sync_outKingdee;
parameters[17].Value = model.suppliers_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
