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);
}
