/// <summary> /// 得到一个对象实体 /// </summary> public Model.enter_storage DataRowToModel(DataRow row) { Model.enter_storage model = new Model.enter_storage(); if (row != null) { if (row["enter_id"] != null && row["enter_id"].ToString() != "") { model.enter_id = int.Parse(row["enter_id"].ToString()); } if (row["enter_batch_id"] != null && row["enter_batch_id"].ToString() != "") { model.enter_batch_id = int.Parse(row["enter_batch_id"].ToString()); } if (row["enter_sl_id"] != null && row["enter_sl_id"].ToString() != "") { model.enter_sl_id = int.Parse(row["enter_sl_id"].ToString()); } if (row["enter_amount"] != null && row["enter_amount"].ToString() != "") { model.enter_amount = decimal.Parse(row["enter_amount"].ToString()); } if (row["enter_unit_bulk"] != null && row["enter_unit_bulk"].ToString() != "") { model.enter_unit_bulk = decimal.Parse(row["enter_unit_bulk"].ToString()); } if (row["supplier_id"] != null && row["supplier_id"].ToString() != "") { model.supplier_id = int.Parse(row["supplier_id"].ToString()); } if (row["enter_mat_id"] != null && row["enter_mat_id"].ToString() != "") { model.enter_mat_id = int.Parse(row["enter_mat_id"].ToString()); } if (row["enter_mat_name"] != null) { model.enter_mat_name = row["enter_mat_name"].ToString(); } if (row["enter_fengji_num"] != null && row["enter_fengji_num"].ToString() != "") { model.enter_fengji_num = int.Parse(row["enter_fengji_num"].ToString()); } if (row["enter_date"] != null && row["enter_date"].ToString() != "") { model.enter_date = DateTime.Parse(row["enter_date"].ToString()); } if (row["enter_agent_id"] != null && row["enter_agent_id"].ToString() != "") { model.enter_agent_id = int.Parse(row["enter_agent_id"].ToString()); } if (row["enter_agent_name"] != null) { model.enter_agent_name = row["enter_agent_name"].ToString(); } if (row["enter_comment"] != null) { model.enter_comment = row["enter_comment"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.enter_storage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update enter_storage set "); strSql.Append("enter_batch_id=@enter_batch_id,"); strSql.Append("enter_sl_id=@enter_sl_id,"); strSql.Append("enter_amount=@enter_amount,"); strSql.Append("enter_unit_bulk=@enter_unit_bulk,"); strSql.Append("supplier_id=@supplier_id,"); strSql.Append("enter_mat_id=@enter_mat_id,"); strSql.Append("enter_mat_name=@enter_mat_name,"); strSql.Append("enter_fengji_num=@enter_fengji_num,"); strSql.Append("enter_date=@enter_date,"); strSql.Append("enter_agent_id=@enter_agent_id,"); strSql.Append("enter_agent_name=@enter_agent_name,"); strSql.Append("enter_comment=@enter_comment"); strSql.Append(" where enter_id=@enter_id "); MySqlParameter[] parameters = { new MySqlParameter("@enter_batch_id", MySqlDbType.Int32, 32), new MySqlParameter("@enter_sl_id", MySqlDbType.Int32, 32), new MySqlParameter("@enter_amount", MySqlDbType.Decimal, 15), new MySqlParameter("@enter_unit_bulk", MySqlDbType.Decimal, 15), new MySqlParameter("@supplier_id", MySqlDbType.Int32, 32), new MySqlParameter("@enter_mat_id", MySqlDbType.Int32, 32), new MySqlParameter("@enter_mat_name", MySqlDbType.VarChar, 255), new MySqlParameter("@enter_fengji_num", MySqlDbType.Int32, 128), new MySqlParameter("@enter_date", MySqlDbType.DateTime), new MySqlParameter("@enter_agent_id", MySqlDbType.Int32, 32), new MySqlParameter("@enter_agent_name", MySqlDbType.VarChar, 64), new MySqlParameter("@enter_comment", MySqlDbType.VarChar, 255), new MySqlParameter("@enter_id", MySqlDbType.Int32, 32) }; parameters[0].Value = model.enter_batch_id; parameters[1].Value = model.enter_sl_id; parameters[2].Value = model.enter_amount; parameters[3].Value = model.enter_unit_bulk; parameters[4].Value = model.supplier_id; parameters[5].Value = model.enter_mat_id; parameters[6].Value = model.enter_mat_name; parameters[7].Value = model.enter_fengji_num; parameters[8].Value = model.enter_date; parameters[9].Value = model.enter_agent_id; parameters[10].Value = model.enter_agent_name; parameters[11].Value = model.enter_comment; parameters[12].Value = model.enter_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.enter_storage GetModel(int enter_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select enter_id,enter_batch_id,enter_sl_id,enter_amount,enter_unit_bulk,supplier_id,enter_mat_id,enter_mat_name,enter_fengji_num,enter_date,enter_agent_id,enter_agent_name,enter_comment from enter_storage "); strSql.Append(" where enter_id=@enter_id "); MySqlParameter[] parameters = { new MySqlParameter("@enter_id", MySqlDbType.Int32, 32) }; parameters[0].Value = enter_id; Model.enter_storage model = new Model.enter_storage(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }