private int UpdateMaterial(MaterialMsg material)
{
string updateSQL = $"UPDATE {DbTable.F_MATERIAL_NAME} SET {DbTable.F_Material.MATERIAL_AMOUNT} = '{material.MaterialAmount}' " +
$"WHERE {DbTable.F_Material.MATERIAL_CODE} = '{material.MaterialCode}'";
LogHelper.Log.Info($"UpdateMaterial={updateSQL}");
return(SQLServer.ExecuteNonQuery(updateSQL));
}
private int InsertMaterial(MaterialMsg material)
{
string insertSQL = $"INSERT INTO {DbTable.F_MATERIAL_NAME}({DbTable.F_Material.MATERIAL_CODE},{DbTable.F_Material.MATERIAL_AMOUNT}) " +
$"VALUES('{material.MaterialCode}','{material.MaterialAmount}')";
LogHelper.Log.Info($"InsertMaterial={insertSQL}");
return(SQLServer.ExecuteNonQuery(insertSQL));
}
