public bool InsertLocationNo(string StoreHouseID, string LocationNo) { string sql = @"insert into store_house_location(location_no, store_house_id) values('" + LocationNo + "', '" + StoreHouseID + "')"; return(mySqlconn.ExeNonQuery(sql) > 0 ? true : false); }
public int ProductClassAdd(string paramClassName, string paramRemark, string paramEmployeeName, string paramParentID) { string strSql = "INSERT INTO product_class(product_class_name, remark, employee_name, create_date, parent_id) Values ('" + paramClassName + "','" + paramRemark + "','" + paramEmployeeName + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + paramParentID + "')"; int returnValue = 0; returnValue = mysqlconn.ExeNonQuery(strSql); return(returnValue); }
public int ProductAdd(string paramProductID, string paramProductClassID, string paramProductName, string paramProductSpec, string paramUnitID, string paramEmployeeName, string paramRemark) { int returnValue = 0; string strSql = "INSERT INTO product_list(product_id,product_class_id,product_name,product_spec,product_unit_id,createby,remark,create_date) Values ('" + paramProductID + "', '" + paramProductClassID + "','" + paramProductName + "','" + paramProductSpec + "','" + paramUnitID + "','" + paramEmployeeName + "','" + paramRemark + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "')"; returnValue = mysqlconn.ExeNonQuery(strSql); return(returnValue); }
public int Delete(string projectNo) { StringBuilder strSql = new StringBuilder(); strSql.Append(" delete from project where project_no='" + projectNo + "' "); int rows = mySqlconn.ExeNonQuery(strSql.ToString()); return(rows); }
public bool DeleteUser(string username) { string strSql = "delete from users where username = '******'"; return(mySqlconn.ExeNonQuery(strSql) > 0?true:false); }
public bool UnitDelete(string UnitId) { string sql = "delete from product_unit where product_unit_id='" + UnitId + "'"; return(mysqlconn.ExeNonQuery(sql) > 0?true:false); }